sqlldr [message #328194] |
Thu, 19 June 2008 05:51 |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Hi Friends,
My sql loader (home) is installed in D:/oracle/client_1
sql loader path is D:/oracle/client_1/BIN
I have written a bat file where I must specify the above paths.
Can you please help how I can proceed.
Thank you,
Dirish
|
|
|
Re: sqlldr [message #328202 is a reply to message #328194] |
Thu, 19 June 2008 06:26 |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
my bat file is as follows:
set ORACLE_HOME=D:/oracle/client_1
set PATH=D:/oracle/client_1/BIN
sqlldr abc/abc@server1 control=c:/data/loadDataFile.ctl log=loadDataFile.log
|
|
|
|
Re: sqlldr [message #328206 is a reply to message #328194] |
Thu, 19 June 2008 06:36 |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Is that the way i should specify the paths (first 2 lines)?. Because am having an error "sqlldr not found"
|
|
|
|
|
|
Re: sqlldr [message #328375 is a reply to message #328233] |
Thu, 19 June 2008 23:34 |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
yea the program is ok.
when i give the command:
sqlldr abc/abc@server1 control=c:/data/loadDataFile.ctl
this works
|
|
|
Re: sqlldr [message #328380 is a reply to message #328375] |
Fri, 20 June 2008 00:19 |
|
Michel Cadot
Messages: 68728 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Do you the same ORACLE_HOME and PATH inside and outside the batch file?
Don't just say yes, prove it.
Porve all what you say, copy and paste your tests.
Regards
Michel
|
|
|