Page 1 of 1

Unable to load CLOB with 2 GB data. Getting SIGSEGV Error

Posted: Mon Mar 28, 2011 12:53 pm
by nasimul
Hi -

We have a requirement to load CLOB data into Oracle table. I have seen the posts regarding CLOB in this forum but unable to proceed.
If CLOB is having data less than 1.5 MB (approx) then job is working fine with LongVarchar. But whenever the data is coming more than that the job is getting aborted stating following error:
"Operator terminated abnormally: received signal SIGSEGV".

Tha data can reach upto 2 GB.

Can anyone please help on this?

Cheers!
Nasimul

Posted: Mon Mar 28, 2011 1:01 pm
by Nagaraj
Try to use DRS stage (it worked for me) and also i think we need put this column in the end(IBM advice),or try to append the data (for clob column) one after another in a seperate load.