My Oracle Support Banner

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

Last updated on DECEMBER 27, 2019

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 assumetargetdef 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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.