My Oracle Support Banner

Extract Error OGG-10475 Table Skipped Due To NO_SUPPORT From DBA_GOLDENGATE_SUPPORT_MODE (Doc ID 2911435.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

Extract report file has below Warning for a table:-

OGG-10475 PDB [0], object ID [****], table <SCHEMA>.<TABLE> skipped due to NO_SUPPORT from DBA_GOLDENGATE_SUPPORT_MODE view.


SQL> select * from DBA_GOLDENGATE_SUPPORT_MODE where object_name='<TABLE>';
OWNER OBJECT_NAME SUPPORT_MODE
--------------- -------------------- --------------------
<OWNER> <TABLE> NONE

Table has a unique index on a column varchar > 1000chars.On changing this unique index to nonunique, replication is working for this table.
  

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.