Problem in loading the file using Oracle stage

bkumar103 · Post by **bkumar103** » Mon Oct 06, 2008 7:15 am

Hi,
I have a table with following structure:
col1 varchar(20),
col2 date,
col3 varchar(15)

where col1 is the primary key

i have the records in a flat file, fields delimited by the pipe which needs to be loaded into the table.

I am using the upsert statement. where i have to update the records based on the primary key.

But when i run the DS job, the job aborts saying SIGSEV error. Its does not give any other clue.

Could anybody faced such issue and what could be the reason?

Thanks for your help.
Birendra

bkumar103 · Post by **bkumar103** » Wed Oct 08, 2008 9:13 am

The problem does not occur if i set the insert array size to 1.
Any thought why it happens like this.

ketfos · Post by **ketfos** » Wed Oct 08, 2008 9:59 am

You should check for memory and swap size param.