My Oracle Support Banner

Replicat is not applying records in CDR configuration (Doc ID 2554674.1)

Last updated on DECEMBER 16, 2019

Applies to:

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

Symptoms

Replicat was applying records to target table with following CDR configuration, which was causing data mismatch between source & target tables.


MAP schema.table,TARGET schema.table, &
COMPARECOLS (ON UPDATE ALL, ON DELETE ALL), &
RESOLVECONFLICT (INSERTROWEXISTS, (DEFAULT, USEMAX (LAST_UPDATE_DT))), &
RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (LAST_UPDATE_DT))), &
RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, OVERWRITE)), &
RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE)), &
RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD));

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
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.