OGG-01161 encountered in Pump After Table Change in DDL replication setup (Doc ID 2038217.1)

Last updated on JANUARY 18, 2017

Applies to:

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

Symptoms

A new column is added to a table PROG_XXX at the source DB. After the table change, the pump starts to encountered the below error.

2015-07-23 13:25:43 ERROR OGG-01161 Oracle GoldenGate Capture for Oracle, ppctest1.prm: Bad column index (18) specified for table SYSADM.PROG_XXX, max columns = 18.

Changes

 Add a new column to an existing table PROG_XXX at the source DB.

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