Oracle SQL LOADER not working for direct path
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Tue May 31, 2005 3:44 pm
Oracle SQL LOADER not working for direct path
The Oracle SQL Enterprise stage with LOAD option is working fine if I use the conventional PATH. But the same job is not working if I use the direct path. In the log file it is saying 'table or view does not exist'. In my case the ETL server and the Database server is different. Is than an issue? Please help.
-
- Participant
- Posts: 9
- Joined: Tue May 31, 2005 3:44 pm
-
- Participant
- Posts: 9
- Joined: Tue May 31, 2005 3:44 pm
-
- Participant
- Posts: 3
- Joined: Wed Aug 26, 2009 4:50 am
You have to point your attention on Oracle client versions.sidharthasaha wrote:Is it because we are uysing a lower version of Oracle. The datastage version is 7.5.1 and the oracle version is 8i.
If your ETL Oracle client version is higher than your DATA Oracle Client version then you CAN'T load data in Direct path, cause Oracle itself does not allow it. So, you have to load data in conventional path setting the datastage environment variable (APT_ORACLE_LOAD_OPTIONS) as keshav0307 suggested, that is, at least, OPTIONS(DIRECT=FALSE).
Hope to be helpful even if a bit late ^_^.
Hi Keshav ,
Thanks for detailed explaination .You have mentioned
"
If APT_ORACLE_LOAD_OPTIONS is used to set PARALLEL to FALSE,
then you must set the execution mode of the stage to run sequentially on
the Advanced tab of the Stage page "
Could anybody help me in clarifying the below question
If execution mode is not changed into sequential and if i mention PARALLEL = FALSE then still it will load in sequential ?
Thanks all
Thanks for detailed explaination .You have mentioned
"
If APT_ORACLE_LOAD_OPTIONS is used to set PARALLEL to FALSE,
then you must set the execution mode of the stage to run sequentially on
the Advanced tab of the Stage page "
Could anybody help me in clarifying the below question
If execution mode is not changed into sequential and if i mention PARALLEL = FALSE then still it will load in sequential ?
Thanks all