Home » RDBMS Server » Server Utilities » sqlloader for windows
sqlloader for windows [message #72983] Thu, 08 January 2004 16:02 Go to next message
James
Messages: 120
Registered: June 2000
Senior Member
I used sql*loader on Unix platform.
I had my load.ctl file and data file in unix directory
and run sqlldr command in shell prompt.
Now I work on Windows XP. Where I have to run this utility and keep my load.ctl file and data file?

Thanks.
Re: sqlloader for windows [message #72984 is a reply to message #72983] Fri, 09 January 2004 02:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
sqlldr should be in ORACLE_HOME/bin as in windows.
regarding the control files and log files , u can have them where ever u want. Just give the full path to them in sqlldr command line
Re: sqlloader for windows [message #72986 is a reply to message #72983] Fri, 09 January 2004 03:19 Go to previous messageGo to next message
James
Messages: 120
Registered: June 2000
Senior Member
I found it. For example, it's in
C:oracleora92binsqlldr.exe
my load.ctl in ctempload.ctl
Should I run command from dos inviroment,
sqlldr control=c:tempload.ctl ...
thanks.
Re: sqlloader for windows [message #72988 is a reply to message #72986] Fri, 09 January 2004 06:30 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
yes
Previous Topic: Using SQL Loader for Migration
Next Topic: listener not Running on SCO UNIX Operating System with ORACLE 7.1.6.2
Goto Forum:
  


Current Time: Tue Dec 24 20:24:58 CST 2024