OGG: Replicat is inserting an ASCII '0' value instead of a true NULL value in Oracle 19c target but not in 11g DB target
(Doc ID 2859643.1)
Last updated on APRIL 17, 2023
Applies to:Oracle GoldenGate - Version 22.214.171.124.4 and later
Information in this document applies to any platform.
When inserting NULL Character values in to the database, OGG is inserting an ASCII '0' value instead of a true NULL value.
This causes data compare scripts to fail validation.
TANDEM non-Stop running GGS 12.2.3
Oracle Exadata 19c
When upgrading to a OGG 12+ where NOBINARYCHARS is deprecated and no longer functional, strings starting with \0 will get faithfully inserted containing the \0.
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