EXTRACT abend: "Failed to validate table <schema>.<tablename>." (Doc ID 1107278.1)

Last updated on JULY 17, 2017

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 ZZ-0QY 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

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