OraFAQ Forum: Data Integration » invoke SQL*Loader

Home » Developer & Programmer » Data Integration » invoke SQL*Loader (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

invoke SQL*Loader [message #303982]

Mon, 03 March 2008 10:23

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

Report message to a moderator

Re: invoke SQL*Loader [message #304078 is a reply to message #303982]

Tue, 04 March 2008 00:02

Littlefoot
Messages: 21736
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.

Report message to a moderator

Re: invoke SQL*Loader [message #304174 is a reply to message #304078]

Tue, 04 March 2008 07:22

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.

Report message to a moderator

Re: invoke SQL*Loader [message #304175 is a reply to message #304174]

Tue, 04 March 2008 07:28

Littlefoot
Messages: 21736
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>.

Report message to a moderator

Re: invoke SQL*Loader [message #304205 is a reply to message #304175]

Tue, 04 March 2008 09:26

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?

Report message to a moderator

Re: invoke SQL*Loader [message #304351 is a reply to message #304205]

Wed, 05 March 2008 00:08

Littlefoot
Messages: 21736
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

Report message to a moderator

Re: invoke SQL*Loader [message #304497 is a reply to message #304351]

Wed, 05 March 2008 07:17

aarti81
Messages: 235
Registered: December 2007
Location: USA

Senior Member

Thank You

Report message to a moderator

Previous Topic:	error while redeploying
Next Topic:	error handling in OWB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 07 23:33:35 CDT 2022