Refresh using datapump

Refresh using datapump

Schema Level

impdp system/***@<service_name> directory=EXPORT_DIR2 dumpfile=<dump_files_names>.dmp logfile=<log_file_name>.log schemas=odb parallel=4

  --- If Dumpfiles locations are different at os level

impdp odb/Ke45LILP@traxmt dumpfile=TEST:TRAXMP_EXP_BKP_2014-07-02_%U.dmp,EXPORT_DIR2:TRAXMP_EXP_BKP_2014-11-24_04.dmp logfile=traxmp_traxmt_today.log schemas=odb parallel=4

Table Level

expdp directory=EXPORT dumpfile=WO_TASK_CARD_200315.dmp logfile=WO_TASK_CARD_200315.log parallel=4 tables=odb.WO_TASK_CARD flashback_time=systimestamp