Page 1 of 1

Setting Parallel in Oracle Bulk Load

Posted: Tue Aug 03, 2010 2:05 am
by synar
Can someone tell me how to make my datastage run bulk load with parallel?
I already setting the APT_ORACLE_LOAD_OPTIONS=OPTIONS(DIRECT=TRUE, PARALLEL=TRUE).

But i don't see the parallel insert in the session browser on toad.

If there something i'am missing to configure beside the environment variable above?

Posted: Tue Aug 03, 2010 6:23 am
by chulett
That should do it, I would think. What does the sqlldr .log file say for the load, what options were in play when it ran?

Posted: Wed Aug 04, 2010 1:13 am
by synar
chulett wrote:That should do it, I would think. What does the sqlldr .log file say for the load, what options were in play when it ran?
Is sqlloader and bulk load is different? I read from the internet they say bulk load is direct path not using sqlloader.

And for your question about sqlldr .log, where i can find this log?

Regards,


Synar

Posted: Wed Aug 04, 2010 6:32 am
by chulett
For Oracle those two terms are synonymous and the log file should be in your "scratch" area, from what I recall.