Replicat reports OGG-06441 message for a Table with valid unique key column
(Doc ID 2754696.1)
Last updated on JULY 20, 2024
Applies to:
Oracle GoldenGate - Version 19.1.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Replicat is not able to use the unique index available for the table and thus logging this into the rpt:
2019-06-07 12:04:59 INFO OGG-06441 Unique key XXX_UK for table <TABLE_NAME> cannot be used due to the inclusion of virtual columns, or user-defined datatypes, or extended long varchar columns, or function-based
index columns.
It will then abend with ORA-1403 due to the all table columns used to identify the record.
Changes
N/A
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 |