Home » Developer & Programmer » Data Integration » invoke SQL*Loader (oracle 10g)
invoke SQL*Loader [message #303982] Mon, 03 March 2008 10:23 Go to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Hi All
How can i invoke the SQL*Loader. I'm using Oracle 10g version 1.0 and Windows XP version package 2.

Thanks In Advance
Re: invoke SQL*Loader [message #304078 is a reply to message #303982] Tue, 04 March 2008 00:02 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If your question refers to invoking SQL*Loader from Oracle Warehouse Builder, I wouldn't know.

But, if it is a general question, here you are: SQL*Loader is a utility which is to be run at the command prompt. For example, using the 'test' control file, it would look like this:
C:\> SQLLDR userid=scott/tiger@ora10 control=test.ctl log=test.log

If you're interested in reading, check the SQL*Loader utility manual.
Re: invoke SQL*Loader [message #304174 is a reply to message #304078] Tue, 04 March 2008 07:22 Go to previous messageGo to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Thanks, but i'm on the windows OS and where should i type the command in SQL*Plus? Thank You once again.
Re: invoke SQL*Loader [message #304175 is a reply to message #304174] Tue, 04 March 2008 07:28 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I didn't say "in SQL*Plus", but "at the command prompt". On MS WIndows XP, you can find it under Start - All Programs - Accessories - Command prompt.
Or, Start - Run - cmd <press Enter>.
Re: invoke SQL*Loader [message #304205 is a reply to message #304175] Tue, 04 March 2008 09:26 Go to previous messageGo to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Thank You very much, and where should i store the contril file and rest of the files?
Re: invoke SQL*Loader [message #304351 is a reply to message #304205] Wed, 05 March 2008 00:08 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Into any directory you wish. Just make sure that you either use full path to these files, or change the working directory into the one that contains these files (a simpler way in my opinion).

For example: create a directory named c:\oracle\my_loader and store control file and input data file in there.

Open the command prompt window and type
> cd c:\oracle\my_loader --> change working directory
> sqlldr blabla --> run SQL*Loader
Re: invoke SQL*Loader [message #304497 is a reply to message #304351] Wed, 05 March 2008 07:17 Go to previous message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Thank You
Previous Topic: error while redeploying
Next Topic: error handling in OWB
Goto Forum:
  


Current Time: Fri Mar 29 00:52:06 CDT 2024