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 19.1.0.0.4 and laterInformation in this document applies to any platform.
Symptoms
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.
Source:
TANDEM non-Stop running GGS 12.2.3
Target:
Oracle Exadata 19c
CharSet UTF8
Changes
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.
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 |
| References |