My Oracle Support Banner

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 SEPTEMBER 20, 2022

Applies to:

Oracle GoldenGate - Version 19.1.0.0.4 and later
Information 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


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