My Oracle Support Banner

Veridata compare shows rows out-of-sync that are actually in-sync. (Doc ID 1305085.1)

Last updated on FEBRUARY 07, 2020

Applies to:

Oracle GoldenGate Veridata - Version 2.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 28-Sep-2012***

Purpose

Veridata comparsion indicated that rows are out-of-sync. But based on Sqlplus queries, the rows are identical:

-source
select ora_hash(title),dbms_utility.get_hash_value(title,1,1024), title, transactionguid from <schema name>.<table name>@<service > where transactionguid = 'i0ad60d0d0000012e8b2f1d82d09585c4'
1944930782 479 § 16:206. Form—Sample jury questions following i0ad60d0d0000012e8b2f1d82d09585c4

--target
select ora_hash(title),dbms_utility.get_hash_value(title,1,1024), title, transactionguid from <schema name>.<table name> where transactionguid = 'i0ad60d0d0000012e8b2f1d82d09585c4'
1944930782 479 § 16:206. Form—Sample jury questions following i0ad60d0d0000012e8b2f1d82d09585c4

Troubleshooting Steps

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
Purpose
Troubleshooting Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.