OGG-01161 Bad Column Index Even When Tables Have Same Structure
Last updated on JULY 17, 2017
Applies to:Oracle GoldenGate - Version 22.214.171.124.0 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