Oracle Data Pump (expdp and impdp) in Oracle Database 10g and above

22 January 2013 · PLSQL · Recipe · 1070 visite

Import

CREATE OR REPLACE DIRECTORY RIDDELIMPORT AS 'C:\RIDDELIMPORT'
/
GRANT READ, WRITE ON DIRECTORY RIDDELIMPORT TO SOFIDUSR;
/

from the command prompt execute:

impdp sofidusr/XXPASSWORDXX directory=RIDDELIMPORT dumpfile=EXPDAT.DMP logfile=immmp.log
/

impdp sofidusr/xxxxx dumpfile=EXP_DELEGHERID directory=RIDDELIMPORT schemas=sofidusr logfile=impRiddel.log

Export

CREATE OR REPLACE DIRECTORY RIDDELEXPORT AS 'C:\RIDDELEXPORT'
/

GRANT READ, WRITE ON DIRECTORY RIDDELEXPORT TO SOFIDUSR;
/

in the command prompt execute:

expdp sofidusr/XXPASSWORDXX full=y directory=RIDDELEXPORT dumpfile=RIDDEL.DMP logfile=immmp.log
/