APT_ORACLE_LOAD_OPTIONS Issue

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
koti9
Participant
Posts: 52
Joined: Wed Nov 09, 2005 10:51 am

APT_ORACLE_LOAD_OPTIONS Issue

Post by koti9 »

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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
koti9
Participant
Posts: 52
Joined: Wed Nov 09, 2005 10:51 am

Post by koti9 »

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
koti9
Participant
Posts: 52
Joined: Wed Nov 09, 2005 10:51 am

Post by koti9 »

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
Post Reply