SQL*Loader [message #358095] |
Sat, 08 November 2008 09:00 |
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 #358097 is a reply to message #358096] |
Sat, 08 November 2008 09:24 |
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 #358109 is a reply to message #358106] |
Sat, 08 November 2008 10:47 |
|
Barbara Boehmer
Messages: 9101 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.
|
|
|