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

Last updated on JULY 20, 2024

Applies to:

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

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