GoldenGate Classic Extract Fails With OGG-01959 "The IOT is created with the COMPRESS option to use key compression"

(Doc ID 1504561.1)

Last updated on MAY 16, 2016

Applies to:

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

Symptoms

Extract fails with below error when replicating an IOT (index-organized-table) with COMPRESS option.

OGG-01959 Failed to validate table <schema>.<table_name>. The IOT is created with the COMPRESS option to use key compression.

The error does not occur on previous versions.

Changes

Upgraded Oracle GoldenGate to 11.2.1.x.x

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