...
| Note | ||||||
|---|---|---|---|---|---|---|
If the Dbvisit Replicate console is not running then:
|
Confirm the data is replicated
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
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%