GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

GoldenGate extract LOB datatypes encountering buffer overflow error

edited Sep 21, 2012 8:24AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
I'm trying to extract a table with LOB datatypes but encountering a buffer overflow error -- possibly due to the length of the LOB exceeded the LOB buffer size.  

Here's the error when running the extract process -

Database Language and Character Set:

NLS_LANG         = "AMERICAN_AMERICA.UTF8" 

NLS_LANGUAGE     = "AMERICAN" 

NLS_TERRITORY    = "AMERICA" 

NLS_CHARACTERSET = "UTF8" 

2012-09-20 00:42:50  INFO    OGG-01478  Output file ./dirdat/initload.dat is using format RELEASE 11.2.

2012-09-20 00:42:55  INFO    OGG-01226  Socket buffer size set to 27985 (flush size 27985).

Processing table MSDATA.MS_CONTENT_IMAGE

Source Context :

  SourceModule            : [ggdb.ora.udt]

  SourceID                : [/scratch/aime1/adestore/views/aime1_staoa19/oggcore/OpenSys/src/gglib/ggdbora/ociudt.c]

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center