EXTRACT ENTERS INFINITE LOOP WHEN RESOLVING METADATA FOR TABLE WITH NON SUPPORTED TYPES
Last updated on MAY 16, 2017
Applies to:Oracle GoldenGate - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Extract process is entering in a loop when trying to process excluded non supported types
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';”.
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