My Oracle Support Banner

EXTRACT abend: "Failed To Validate Table <Schema>.<Tablename>." (Doc ID 1107278.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle GoldenGate - Version 10.0.0.0 to 10.4.0.32 [Release 10.0.0 to 10.4.0]
Information in this document applies to any platform.

Symptoms

EXTRACT abend:
GGS ERROR XX-0YY Failed to validate table <schema>.<tablename>. The table is compressed and extract will not be able to extract data from Oracle logs.

But table isn't compressed:

SQL> select compression from dba_tables
where owner = '<owner>' and table_name = '<tablename>';

COMPRESS
--------
DISABLED

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
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.