Table Level Exports:
expdp scott/tiger@Test tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=expdpEMP_DEPT.log
Table Level Imports:
impdp scott/tiger@Test tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=impdpEMP_DEPT.log
Schema Level Exports:
expdp scott/tiger@Test schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT.dmp logfile=expdpSCOTT.log
Schema Level Imports
impdp scott/tiger@Test schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT.dmp logfile=impdpSCOTT.log
Full Database Exports:
Full database export file will generate.
expdp system/password@Test full=Y directory=TEST_DIR dumpfile=DB10G.dmp logfile=expdpDB10G.log
Full Database Imports:
impdp system/password@Test full=Y directory=TEST_DIR dumpfile=DB10G.dmp logfile=impdpDB10G.log
For Any Queries Feel Free to Contact.
No comments:
Post a Comment
Thank You For Comment