My Oracle Support Banner

Replicat reports OGG-06441 message for a Table with valid unique key column (Doc ID 2754696.1)

Last updated on APRIL 17, 2023

Applies to:

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


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.





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

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