...
To confirm that the data is replicated the following query can be run on both the source and the target database
| No Format |
|---|
sqlplus oe/oe
|
| No Format |
|---|
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 same number on the source and target database when the replication is at 100%