Sunday, December 30, 2012

Exports/Imports IMPDP and EXPDP


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