What is Data instantiation
...
| No Format |
|---|
cd $HOME/scripts ./record_count.bash [oracle@source scripts]$ ./record_count.bash TABLE_NAME TTORCL_SRCSOURCE TTORCL_TRGTARGET ------------------------------ ----------- ----------- 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 |
The output should indicate there are no tables in the REPOE schema in the target database.
Create the Database Link
A database link is a schema object in one database that enables you to access objects on another database. After you have created a database link, you can use it to refer to tables and views on the other database. Oracle Datapumps use the database link to gather the data from remote database - in our example from source database and insert them to target database.
The APPLY.sh script created by the Setup Wizard for instantiating the target schema using DataPump export/import over a database link. This database link must be created for the script to work.
...
3. On the source server, as oracle, in the $HOME/replicate directory, execute the APPLY.sh script. This script will take approximately 3 - 9 minutes to complete depending on your host machine.
| No Format |
|---|
cd $HOME/replicate ./APPLY.sh |
...
On the source machine, as oracle, in the $HOME/replicate directory, execute the record_count.bash script to check the record counts between the two databases.
| No Format |
|---|
cd $HOME/replicatescripts ./record_count.bash TABLE_NAME TTORCL_SRCSOURCE TTORCL_TRGTARGET ------------------------------ ----------- ----------- ADDRESSES 750003 750003 CARD_DETAILS 750003 750003 CUSTOMERS 500003 500003 INVENTORIES 900131 900131 LOGON 1191500 1191500 ORDERENTRY_METADATA 4 4 ORDERS 714895 714895 ORDER_ITEMS 2143687 2143687 PRODUCT_DESCRIPTIONS 1000 1000 PRODUCT_INFORMATION 1000 1000 WAREHOUSES 1000 1000 11 rows selected. Sum of orders TTORCL_SRC SOURCE TTORCL_TRGTARGET ------------- ------------------ ------------------ ORDERS $3,572,944,731.00 $3,572,944,731.00 11 rows selected. |
Because there was no transaction activity in the source database, the source and target database record counts should be the same.
...