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