OGG Can Insert Duplicate Rows When There Is No Unique Index Primary Key UI PK Defined (Doc ID 1350948.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle GoldenGate - Version 9.5_EA and later
Information in this document applies to any platform.
***Checked for relevance on 13-May-2013***

Symptoms

Target table with no UI or PK has duplicate rows after initial load.

Replicat is (may be) using HANDLECOLLISIONS and KEYCOLS

Changes

An initial load.

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