Setting Parallel in Oracle Bulk Load

[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?

[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?

[synar]

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

[chulett]

For Oracle those two terms are synonymous and the log file should be in your "scratch" area, from what I recall.