To confirm that the data is replicated the following query can be run on both the source and the target database.
1. Connect to the source database.
sqlplus oe/oe@ttorcl_src
Run the query.
SQL> select to_char(sum(order_total),'$999,999,999,999.00') "Total Orders" from orders; Total Orders -------------------- $7,317,074,993.00
2. Connect to the target database.
sqlplus oe/oe@ttorcl_trg
Run the query.
SQL> select to_char(sum(order_total),'$999,999,999,999.00') "Total Orders" from orders; Total Orders -------------------- $7,317,074,993.00
This query should give the approximately the same number on the source and target database when the replication is < 100%.
Run the queries several times to see that the numbers are updating on both the source and target database.
If the replication is at 100% then the numbers will be the same.
Add Comment