KEYCOLS Not Working In GG 12c To Enforce Key/uniqueness
(Doc ID 2134420.1)
Last updated on DECEMBER 18, 2019
Applies to:Oracle GoldenGate - Version 184.108.40.206.8 and later
Information in this document applies to any platform.
When doing initial load processing to CDC capture tables, KEYCOLS is not working to enforce the key/uniqueness, duplicate insert records are being created. These are CDC capture tables, just a sequence being used for the primary key, and all records during regular processing are inserted. The issue arises when we do initial load and a record on the source is inserted during that initial load.
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