My Oracle Support Banner

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

Last updated on NOVEMBER 22, 2019

Applies to:

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


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.


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


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.