Sunday, 24 June 2012

expdp/impdp in Oracle Database


Login to database as 'sys' user and execute

CREATE OR REPLACE DIRECTORY dmpdir AS 'D:\Backup';
GRANT READ, WRITE ON DIRECTORY dmpdir TO system;


expdp system/xxxx@SID full=Y directory=dmpdir dumpfile=full_sid.dmp logfile=full_exp_sid.log


impdp system/xxxx@SID full=Y directory=dmpdir dumpfile=full_sid.dmp logfile=full_imp_sid.log

No comments:

Post a Comment