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

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.

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.

Upgraded Oracle GoldenGate to 11.2.1.x.x

	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