Extract is capturing LOB columns even when excluded via COLSEXCEPT parameter (Doc ID 1481329.1)

Last updated on AUGUST 22, 2012

Applies to:

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

Symptoms

 create table gg11_3.clobtst2 (c3 number constraint clobtst2_pk primary key,
c4 blob) lob (c4) store as c4lobseg (disable storage in row);

create table gg11_3.clobtst1 (c1 number constraint clobtst1_pk primary key,
c2 blob) lob (c2) store as c2lobseg (enable storage in row);

TABLE GG11_3.CLOBTST1 , COLSEXCEPT ( C2 );
TABLE GG11_3.CLOBTST2 , COLSEXCEPT ( C4 );

Extract is capturing the excluded LOB columns

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