Home » RDBMS Server » Server Utilities » sqlldr
sqlldr [message #328194] Thu, 19 June 2008 05:51 Go to next message
dirish
Messages: 205
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 Go to previous messageGo to next message
dirish
Messages: 205
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 #328205 is a reply to message #328202] Thu, 19 June 2008 06:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And then?
Your question is even less explicit than your title.

Regards
Michel
Re: sqlldr [message #328206 is a reply to message #328194] Thu, 19 June 2008 06:36 Go to previous messageGo to next message
dirish
Messages: 205
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 #328217 is a reply to message #328206] Thu, 19 June 2008 06:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In Windows it is \ and not / in directory path.

Regards
Michel
Re: sqlldr [message #328219 is a reply to message #328194] Thu, 19 June 2008 07:02 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
yea, in fact i used your mentioned slash (\)
Re: sqlldr [message #328233 is a reply to message #328219] Thu, 19 June 2008 07:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you check you have the program?

Regards
Michel
Re: sqlldr [message #328375 is a reply to message #328233] Thu, 19 June 2008 23:34 Go to previous messageGo to next message
dirish
Messages: 205
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 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Update using sqlldr
Next Topic: Data loading by sql loader and trigger is not working
Goto Forum:
  


Current Time: Sun Dec 04 04:32:34 CST 2016

Total time taken to generate the page: 0.12993 seconds