Replicat Abends With Unique Constraint Error Ora - 00001 On UPDATE For Unique Key Column Which Has MULTIPLE NULL Values
(Doc ID 2144291.1)
Last updated on DECEMBER 27, 2019
Applies to:Oracle GoldenGate - Version 188.8.131.52.14 and later
Information in this document applies to any platform.
Replicat abends with below error. The table in question has a unique key column and data in that column contains null value more than once.
2016-05-20 11:34:12 WARNING OGG-01154 SQL error 1 mapping ABC.tablename to XXXX.tablename ORA-00001: unique constraint (XXXX.tablename) violated SQL UPDATE .......
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