Export and Import Schemas

TO EXPORT

---------------

1     1)      In Command prompt:

                    C:\oraclexe\app>expdp SYSTEM/manager@XE  SCHEMAS=nani   DUMPFILE="xyz.dmp"

->It will store the dump file in ‘C:\oraclexe\app\oracle\admin\XE\dpdump’ location.

2      2)      In SQL Prompt

CREATE OR REPLACE DIRECTORY dmpdir AS 'c:\oraclexe\app\tmp';

GRANT READ,WRITE ON DIRECTORY dmpdir TO nani

C:\oraclexe\app>expdp SYSTEM/manager@XE SCHEMAS=nani DIRECTORY=dmpdir DUMPFILE="xyz.dmp"

->It will store the dump file in ‘C:\oraclexe\app\tmp’ location.

TO IMPORT

 --------------

Place the dump file in ‘C:\oraclexe\app\oracle\admin\XE\dpdump’ then

1    1)      In Command Prompt:

            C:\oraclexe\app>impdp system/manager@XE DUMPFILE=”XYZ.dmp”