What is Data instantiation
...
Data Instantiation using DataPump over a Database Link
1. Ensure that the REPOE schema is clean. Run the following drop script to ensure that there are no REPOE objects. If there are then the DataPump script will fail. Do this by executing the the record_count.bash script script in the the $HOME/replicate directory directory of the the source machine machine. This will show you the record counts for the source and target tables but it will also show you if the target tables have not been created. (which is what you want). If there are then the DataPump script will fail.
| No Format |
|---|
./record_count.bash TABLE_NAME TTORCL_SRC TTORCL_TRG ------------------------------ ----------- ----------- ADDRESSES 750003 *No Table* CARD_DETAILS 750003 *No Table* CUSTOMERS 500003 *No Table* INVENTORIES 900131 *No Table* LOGON 1191500 *No Table* ORDERENTRY_METADATA 4 *No Table* ORDERS 714895 *No Table* ORDER_ITEMS 2143687 *No Table* PRODUCT_DESCRIPTIONS 1000 *No Table* PRODUCT_INFORMATION 1000 *No Table* WAREHOUSES 1000 *No Table* 11 rows selected. Sum of orders TTORCL_SRC TTORCL_TRG ------------- ------------------ ------------------ ORDERS $3,572,944,731.00 $.00 |
...
3. On the source server, as oracle, in the $HOME/dbvrep_XE directory, execute the APPLY.sh script. This script will take approximately 3 - 9 minutes to complete depending on your host machine.
| No Format |
|---|
./APPLY.sh |
The output will be similar to:
...