What is Data instantiation
...
1. Ensure that the REPOE schema is clean. Do this by executing the record_count.bash script in the $HOME/replicate directory of the source 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 |
|---|
cd $HOME/replicate
./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:
...