Wednesday, July 20, 2011

Exclude and Include Option in both EXPDP and IMPDP

EXCLUDE and INCLUDE options are really use full in DATAPUMP.


expdp scott/tiger@testdb directory=test dumpfile=isptool_scott.dmp logfile=isptool_scott.log exclude=TABLE:\"='BONUS'\"


impdp scott/tiger@testdb directory=test dumpfile=isptool_scott.dmp logfile=isptool_test_impdp.log include=TABLE:\"='DEPT'\"



Cheers!!!

No comments:

Post a Comment