My Oracle Support Banner

Replicat issues explicitly column mapping CLOB when using USEDEFAULTS (Doc ID 1632801.1)

Last updated on MARCH 07, 2014

Applies to:

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


When explicitly mapping a clob with content greater than 4K the mapping is ignored if using usedefaults and the mapping uses a function.


GGSCI (rajesgov_us) 72> VIEW PARAMS RE
replicat rora
userid hr password hr
map hr.t, target hr.t, colmap (

The issue is seen only if trail has lob values in segments like below

2013/12/06 11:07:23.000.000 LargeObject          Len  3020 RBA 1880
Name: HR.T
After  Image:                                             Partition 4      e
 0000 0001 0000 0001 0000 0001 0000 0000 0000 0bb8 | ....................
 7878 7878 7878 7878 7878 7878 7878 7878 7878 7878 | xxxxxxxxxxxxxxxxxxxx


To view full details, 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 a vibrant support community of peers and Oracle experts.