To confirm that the data is replicated the following query can be run on both the source and the target database.
1. On the source server, as oracle, in the $HOME/replicate directory, execute the record_count.bash script to check the number of rows in each table and the sum total of all orders in both the source and target databases.
./record_count.bash
This queries 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 should be the same.
0 Comments