NULL TO NULL UPDATE ON COLUMN NOT APPLIED ON TARGET WHEN USING INTEGRATED REPLICAT (Doc ID 2221851.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

 An update to a column having a null value on the source does not get applied
to the target table when using Inegrated Replicat.

CDR was setup for the table using the following definitions:


MAP USR1.T2, TARGET USR2.T2,
COMPARECOLS (ON UPDATE ALL, ON DELETE ALL),
RESOLVECONFLICT (INSERTROWEXISTS, (DEFAULT, OVERWRITE)),
RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE)),
RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, OVERWRITE)),
RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD));

Columns P and D have NULL values at the source and not-NULL values at the
target. The following update executed at the source to resolve the conflict
does not update columns P and D to NULL:

update usr1.t2 set m=m,p=p,d=d where n='01';

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms