Oracle Golden Gate table with a column type NCLOB, replicat abends with mapping error

Mar 4, 2015 2:04PM

Hi All,

any hints on how to properly replicate NCLOB data for a table having NCLOB column data type?

Table structure:

CW_NODE_CONFIG (

"ID" VARCHAR2(16 BYTE) NOT NULL ENABLE,

"ROOTID" VARCHAR2(16 BYTE),

"PARENTID" VARCHAR2(16 BYTE),

"NAME" VARCHAR2(32 BYTE) NOT NULL ENABLE,

"CONFIG" NCLOB,

"CREATED" DATE,

"LASTUPDATEDDATE" DATE,

"UPDATEDBY" VARCHAR2(64 BYTE),

"APPID" NUMBER(9,0) NOT NULL ENABLE,

"DB" VARCHAR2(1024 BYTE)

)

Primary key: ID

Software stack:

-------------------------------------------------

linux

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit

Oracle Golden Gate Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1_FBO

-------------------------------------------------

Have the same table created both on source server and target server.

The table, has a number of columns, one of the columns data type is NCLOB data type)

GoldenGate, Streams and Distributed Database (MOSC)