ERROR OGG-01920 Missing COMPARECOLS column in before image while mapping to target table (Doc ID 2169951.1)

Last updated on FEBRUARY 11, 2020

Applies to:

Goal

 In a bi-directional setup for Oracle database DDL change was done outside of goldengate.

Error recieved:
ERROR OGG-01920 Missing COMPARECOLS column COLNAME  in before image, while mapping to target table OWNER.TABLE_NAME. Add the column to GETBEFORECOLS.

Following parameters were active:
   COMPARECOLS ( ON UPDATE ALL , ON DELETE ALL )

Solution

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