Extract Abending with Table Compression Is Not Supported, Although the Database Doesn't Have Any Compressed Tables (Doc ID 1510691.1)

Last updated on JANUARY 18, 2017

Applies to:

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

Symptoms

Extract abends with the below error displaying only the object id in the error message when the source db is Oracle 11gR2, although the source db does not have any compressed tables:

Eg: 2012-10-30 22:02:00 ERROR OGG-01028 Object with object number 169008 is compressed. Table compression is not supported.

When the error occurs, the extract process would not provide the object name as well to exclude it from replication.

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