My Oracle Support Banner

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 JANUARY 11, 2023

Applies to:

Oracle GoldenGate - Version 11.2.1.0.14 and later
Information in this document applies to any platform.

Symptoms

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 .......

Changes

 

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.