KEYCOLS Not Working In GG 12c To Enforce Key/uniqueness
Last updated on JULY 03, 2017
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.
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