EXTRACT ENTERS INFINITE LOOP WHEN RESOLVING METADATA FOR TABLE WITH NON SUPPORTED TYPES
(Doc ID 1528319.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle GoldenGate - Version 184.108.40.206.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';”.
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