Veridata Reports Table In Sync But Counts In Source And Target Db Are Different
(Doc ID 2136839.1)
Last updated on MAY 11, 2022
Applies to:
Oracle GoldenGate Veridata - Version 12.1.3.0.1 and laterInformation in this document applies to any platform.
Symptoms
Ran a Veridata compare report with 1 compare-pair ( 1 table ) configuration. The rowcounts of the table in the source and target DB are different but Veridata reports the table to be in sync
Source:
SQL> select count(*) from <schema>.<table1>;
COUNT(*)
----------
182254
Target:
SQL> select count(*) from <schema>.<table1>;
COUNT(*)
----------
182252
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |