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

Cause

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
Symptoms
Changes
Cause
Solution
References


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