EXP/IMP

CREATE OR REPLACE <DIRECTORY> AS '<PATH>';

TABLE1
TABLE2
TABLE3
TABLE4

hostname[oracle]_SID1> cat EXPDP_<SID>_GECM_ICP_TABLES_28MAR16.par
USERID=system/********
DIRECTORY=EXPDP_DIR
DUMPFILE=EXP_<SID>_<SCHEMA>_TABLES%U.dmp
JOB_NAME=EXP_<SID>_<SCHEMA>
LOGFILE=EXP_<SID>_<SCHEMA>_TABLES_28MAR16.log
PARALLEL=4
tables=<SCHEMA>.TABLE1,<SCHEMA>.TABLE2,<SCHEMA>.TABLE2_EXT,<SCHEMA>.TABLE4
hostname[oracle]_SID1>

hostname[oracle]_SID1> cat IMPDP_<SID>_<SCHEMA>_TABLES_28MAR16.par
USERID=system/********
DIRECTORY=EXPDP_DIR
DUMPFILE=EXP_<SID>_<SCHEMA>_TABLES%U.dmp
JOB_NAME=IMP_<SID>_<SCHEMA>_TABLES
LOGFILE=<SID>_IMP_<SID>_<SCHEMA>_TABLES.log
REMAP_SCHEMA=<SCHEMA>:<SCHEMA>
PARALLEL=4
hostname[oracle]_SID1>

time impdp parfile=IMPDP_<SID>_<SCHEMA>_TABLES_28MAR16.par 2>&1 | tee IMPDP_<SID>_<SCHEMA>_TABLES_28MAR16.log

nohup expdp userid=\'/as sysdba\' parfile=***.par &
+++++++++++++++
cat ***.par
+++++++++++++++
schemas=apps
include=TABLE:"IN ('****','****','***'
)"
directory=OPATCHING
dumpfile=<file_name>.dmp
logfile=<file_name>.log


impdp \'/ as sysdba\' DUMPFILE=***.dmp directory=OPATCHING LOGFILE=***.log REMAP_SCHEMA=apps:geaecust REMAP_TABLESPACE=apps_ts_tx_data:ge_tx_data table_exists_action=REPLACE