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 and later
Information in this document applies to any platform.


Here is the error detail from report file:-



 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.


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