Home » RDBMS Server » Server Utilities » SQL*Loader (oracle,9i,MAC OS)
SQL*Loader [message #358095] Sat, 08 November 2008 09:00 Go to next message
gauravsunil
Messages: 68
Registered: August 2007
Location: bhubaneswar
Member
Hi Experts,

I am very new for SQL*Loader.
I want to load a table through a file.
Could you please help me how should i proceed.

Please let me know for any further information.

Thanks and Regards,
Sunil
Re: SQL*Loader [message #358096 is a reply to message #358095] Sat, 08 November 2008 09:08 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Step 1:

Read the SQL*Loader documentation

There are dozens of examples in the "Case Studies" chapter.
Re: SQL*Loader [message #358097 is a reply to message #358096] Sat, 08 November 2008 09:24 Go to previous messageGo to next message
gauravsunil
Messages: 68
Registered: August 2007
Location: bhubaneswar
Member
Thomas,Thanks a lot for replying fast.

Whenever I ams trying the query in iSQL plus terminal,
sqlldr USERID=scott/tiger CONTROL=ulcase1.ctl LOG=ulcase1.log


I am getting the following exception:

SP2-0851: Command beginning "sqlldr USE..." is not available in iSQL*Plus



Please advise me on the above error.

Thanks and Regards,
Sunil
Re: SQL*Loader [message #358101 is a reply to message #358097] Sat, 08 November 2008 10:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is SQL*Loader a iSQLPlus command?

And once more DON'T RATE YOUR OWN TOPIC.

Regards
Michel

[Updated on: Sat, 08 November 2008 10:13]

Report message to a moderator

Re: SQL*Loader [message #358106 is a reply to message #358101] Sat, 08 November 2008 10:28 Go to previous messageGo to next message
gauravsunil
Messages: 68
Registered: August 2007
Location: bhubaneswar
Member
Michel, could you please tell me where I should run the
SQL*Loader query.

Thanks and Regards,
Sunil
Re: SQL*Loader [message #358108 is a reply to message #358106] Sat, 08 November 2008 10:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you read the link Thomas provided you?
Of course no otherwise you didn't post this question.

Regards
Michel
Re: SQL*Loader [message #358109 is a reply to message #358106] Sat, 08 November 2008 10:47 Go to previous message
Barbara Boehmer
Messages: 8635
Registered: November 2002
Location: California, USA
Senior Member
Sqlldr is an operating system command, so you either run it from an operating system prompt or run it from SQL*Plus preceded by the HOST command.
Previous Topic: Importing dump
Next Topic: impdat
Goto Forum:
  


Current Time: Thu Dec 08 04:12:18 CST 2016

Total time taken to generate the page: 0.09242 seconds