For Particular Tables
expdp TEST/TEST@ORCL tables=EMP,DEPT directory=TEST_DIR dumpfile=test.dmp logfile=test.log impdp TEST/TEST@ORCL tables=EMP,DEPT directory=TEST_DIR dumpfile=test.dmp logfile=test.log
For
Schema Exports/Imports
expdp TEST/TEST@ORCL schemas=HR dumpfile=test.dmp logfile=test.log impdp TEST/TEST@ORCL schemas=HR dumpfile=test.dmp logfile=test.log
import recreate the new table as in the dumpfile.
impdp dumpfile=emp.dmp logfile=imp1.log table_exists_action=replace
No comments:
Post a Comment