...
| No Format | ||
|---|---|---|
| ||
impdp SYSTEM/xxx@d112f_dbvisit230 table_exists_action=TRUNCATE network_link=d112f_dbvisit210 directory=DATA_PUMP_DIR flashback_scn=297940636 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=OE_CUSTOMERS.log JOB_NAME=DP_d112f_0001 |
| Note |
|---|
If the import is going in a different tablespace, make sure you specify that with a parameter REMAP_TABLESPACE=source_tablespace:target_tablespace |
In this example the
- Source TNS name is: d112f_dbvisit210
- Target TNS name is: d112f_dbvisit230
- The flashback_scn is 297940636. This is the starting point for replication and all data before this point will be exported from the source database and into the target database.
The network_link is: d112f_dbvisit210. This has to be created manually in the target database with the following command:
...
- Run the setup wizard
- Run the resulting *-all.sh or *-all.bat script
- Start Data Pump
- Start the Mine MINE process. You do not have to wait until Data Pump has completed before started the Mine MINE process
- Start the Apply APPLY process once Data Pump has completed and the data instantiation on the target database has completed
...