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