datapump 1

Enovia Test Server

/home/app/oracle/admin/orcl/dpdump

　

Import DB dump file placed in the below mentioned location.

　

/home/app/oracle/admin/orcl/dpdump

File name: TESTSERVER_01Feb2018.dmp

　

Source schema Name = V6R2015X

Destination schema Name = V6R2015X_EBS

　

How to Show Content of Oracle Dump/Export (.dmp) File

IMP USERID=scott/tiger FULL=y SHOW=y FILE=oraexp.dmp > oraexp_dmp.sql 2>&1

　

　

expdp V6R2015X/V6R2015X@orcl DUMPFILE=TESTSERVER_01Feb2018.dmp logfile=TESTSERVER_01Feb2018.log directory=data_pump_dir

　

impdp V6R2015X/V6R2015X@orcl DUMPFILE=TESTSERVER_01Feb2018.dmp logfile=TESTSERVER_01Feb2018_imp.log directory=data_pump_dir

　

　

impdp directory=DATA_PUMP_DIR dumpfile=V6R2015X.dmp logfile=V6R2015X_imp.log remap_schema=V6R2015X:V6R2015X_EBS remap_tablespace=MX_DATA15X:MX_DATA_EBS remap_tablespace=MX_INDEX15XV6:MX_INDEX_EBS table_exists_action=REPLACE

　

　

impdp V6R2015X/V6R2015X@orcl DUMPFILE=TESTSERVER_01Feb2018.dmp logfile=TESTSERVER_01Feb2018_imp.log directory=data_pump_dir

　

impdp V6R2015X/V6R2015X directory=DATA_PUMP_DIR dumpfile=V6R2015X.dmp logfile=V6R2015X_imp.log remap_schema=V6R2015X:V6R2015X_EBS table_exists_action=REPLACE