echo ========================================
echo EXPORT
echo ========================================
expdp SYSTEM/xxxxxx@d112f_dbvisit210 dumpfile=OE_SHEMA.dmp directory=DATA_PUMP_DIR \
flashback_scn=xxxxxxxxxx tables=OE.CUSTOMERS,OE.INVENTORIES,OE.LOGON,\
OE.ORDERENTRY_METADATA,OE.ORDERS,OE.ORDER_ITEMS,\
OE.PRODUCT_DESCRIPTIONS,OE.PRODUCT_INFORMATION,\
OE.STRESSTESTTABLE,OE.WAREHOUSES \
logfile=exp_OE_schema.log JOB_NAME=DP_d112f_0001
echo ========================================
echo IMPORT
echo ========================================
impdp SYSTEM/xxxx@d112f_dbvisit230 dumpfile=OE_SHEMA.dmp directory=DATA_PUMP_DIR logfile=imp_OE_SCHEMA.log |