EXTRACT ENTERS INFINITE LOOP WHEN RESOLVING METADATA FOR TABLE WITH NON SUPPORTED TYPES

(Doc ID 1528319.1)

Last updated on MAY 16, 2017

Applies to:

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

Symptoms

Extract process is entering in a loop when trying to process excluded non supported types

Changes

Create a table with UDT which is a synonym of another UDT. For example, "ANYDATA" type, or "SDO_GEOMETRY".

create table test  (id number, data anydata);


When using COLS for including all columns except the unsupported column.

GoldenGate extract is still trying to process the unsupported type and it enters in a loop while trying to resolve the type.

TABLE scott. test , COLS (id);


Using a session browser the extract is processing this SQL statement; “SELECT table_owner, table_name FROM all_synonyms WHERE owner = 'PUBLIC' AND synonym_name = 'xxx';”.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms