OGG-01161 Bad Column Index Even When Tables Have Same Structure (Doc ID 2165535.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

Here is the error detail from report file:-

 

Changes

 There could be the situation where assumetarget def is define and your source and target table have same structure ( suppose 18 columns )  and due to some change request , you have to add a new column in source table and then same column was added on target side.

DML application run on table and then all of sudden , you have to revert back the change request ( DDL changes ) and you drop that newly added column from source and target also. But data run after DDL changes captured by extract and present in trail but did not get replicated in target table , So kind of situation can come.

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