Goldengate Extract Abends with OGG-01902 Unsupported datatype for column COLUMN_NAME specified in GETBEFORECOLS clause (Doc ID 1928893.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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

Goal

GOLDENGATE extract Abends due to "OGG-01902 Unsupported datatype for column COLUMN_NAME specified in GETBEFORECOLS clause."

This COLUMN_NAME is a CLOB column and NOT NULL on source  table, so we need to get the before image for any rows.
 

Solution

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