My Oracle Support Banner

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

Last updated on MARCH 04, 2021

Applies to:

Oracle GoldenGate - Version 19.1.0.0.0 and later
Information 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


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