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
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
No comments:
Post a Comment