DSXchange

Hello,

I am trying to bulk load the data, i also overrided the APT_ORACLE_LOAD_OPTIONS with "OPTIONS(DIRECT=TRUE,PARALLEL=TRUE)", however its not working, when i check the explain plan in Oracle(target db), its always going to Conventional Path though i set Direct Path as True. Did anyone face this? Please let me know.
Thanks for your help in advance.

Thanks & Regards
Koti

What stage are you using? How is it configured? I'd also be curious if your target table is actually "bulk loadable"... primarily that it has no indexes.

Hi Craig,

I am using Oracle Connector Stage. I put the bulk load option on and no indexes. Please let me know if you faced this.


Thanks & Regards
Koti

I was able to use "DIRECT=TRUE" explicitly in sqlldr command using external target, by taking the input from dataset using 'data=\"-\"' i.e.stdin