Import and Export DataBase Oracle 10g

Here are steps to exoprt an existing Database in Oracle 10g.

1# First of all you must create USER with the same name ,password and privileges using SQL PLUS,to import DATABASE to.



TO EXPORT DB:



3# START then CMD then write: the following command:

EXP USERNEME/PASSOWRD@ORCL FILE=D:\FILENAME.DMP

then press ENTER key



Before importing dmp file you must :

-Create user with the same name and password

-set Arabic Character in DB  like here...



TO IMPORT DB:

2# Copy the FILENAME.DMP file to the new location you wish to import

3# START then CMD then write: the following command:

IMP USERNEME/PASSOWRD@ORCL FILE=D:\FILENAME.DMP Full=Y

then press ENTER key





Source: ArabOUG