Home » Server Options » Replication » Verifying Row Counts for Tables
Verifying Row Counts for Tables [message #75272] Mon, 16 September 2002 17:34
Peter Barnett
Messages: 2
Registered: September 2002
Junior Member
We are starting into production using Oracle Advanced Replication for fail over. While randomly checking some tables I found a huge difference in the number of rows for some of the tables. There was nothing in the deferred transaction queue to account for this. The databases have been replicating for months and have no replication errors reported.

Does anyone have any scripts handy to verify row counts on a regular basis? I am thinking of putting a daily job in cron to make sure we do not get too far out of line.
Previous Topic: MV/Snapshot versus Table
Next Topic: Can't startup standby database successfully
Goto Forum:

Current Time: Thu May 19 19:16:14 CDT 2022