Extract limitations for OLTP compressed tables – Chained Rows (Doc ID 2210290.1)

Last updated on DECEMBER 02, 2016

Applies to:

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

Symptoms

Replicat crashes on bad column index. ERROR OGG-01164
Column index (0) out of sequence for table <owner>.<table_name>, last column index = 0.

Although the incident becomes visible at Replicat on the target database, the root cause is related to the integrated Extract at the source database. Integrated Extract has limitations to extract OLTP compressed tables with chained rows.

This issue can cause silent data divergence between source and target database.



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