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 12.1.2.1.8 and laterInformation in this document applies to any platform.
Symptoms
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.
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 |