Page 1 of 1

probleme with the oracle bulk loader

Posted: Wed Jan 24, 2007 11:27 am
by bart12872
Hello,

I use the orabulk to populate a table. but, when i have to idantical line, (Normally, it's an ORA-0001 error, primary key constraint violation), I don't know if it's Datastage or oracle, but my constraint is desactivated and the two lines are insert.

How can I reject those lines using the orabulk stage ?

thanks,
bart.

Posted: Wed Jan 24, 2007 11:40 am
by chulett
Oracle thing. And you can't. You need to ensure you do not have data to be bulk loaded that would violate any constraints.

Re: probleme with the oracle bulk loader

Posted: Wed Jan 24, 2007 11:41 am
by narasimha
You need to rectify the primary key constraint violation problem before you can bulk load into that table.
Not sure if you can reject these lines using the orabulk stage

Posted: Wed Jan 24, 2007 11:50 am
by DSguru2B
Nop. No rejects from that stage.