Wednesday, February 1, 2012

Oracle datapump:IMPDP: A Simple Example ...


Oracle datapump:IMPDP: A Simple Example ...



Import:
CREATE OR REPLACE DIRECTORY test_dir AS '/u01/app/oracle/oradata/';
 


impdp mercurydcd/mercurydcd  directory=TEST_DIR dumpfile=mercurydcd25012012.dmp logfile=impdpmercurydcd25012012.log

impdp IDEAL_WEALTH_X/IDEAL_WEALTH_X  directory=TEST_DIR dumpfile=IDEAL_WEALTH_X_18012012_NEW.DMP logfile=IDEAL_WEALTH_X_18012012_NEW.log

impdp FESMIGRATION/FESMIGRATION  directory=TEST_DIR dumpfile=FESMIGRATION.DMP logfile=FESMIGRATION.log

impdp MFX_4_1_0_KVB/MFX_4_1_0_KVB  directory=TEST_DIR dumpfile=MFX_4_1_0_KVB_DEV27JAN12.DMP logfile=MFX_4_1_0_KVB.log

No comments:

Post a Comment