Home » RDBMS Server » Server Utilities » Having Problems with SQL Loader
Having Problems with SQL Loader [message #266401] Mon, 10 September 2007 14:25 Go to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Can the Experts please help me. I have this BLOB and CLOB object on my C drive that I wanna load in my PUBS schema on my Oracle10g server running on windows. I ran the following commands but it gave me the error below:

E:\>sqlldr pubs/pubs@standby control=ctrlstandby01.ctl

SQL*Loader: Release 10.1.0.2.0 - Production on Mon Sep 10 15:24:15 2007

Copyright (c) 1982, 2004, Oracle. All rights reserved.

SQL*Loader-500: Unable to open file (ctrlstandby01.ctl)
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.

Can you help me please. Actually, I have created a table named LOB_TAB to load this data into .. please how do I go about it.

Thanks and regards,

Cherish
Re: Having Problems with SQL Loader [message #266406 is a reply to message #266401] Mon, 10 September 2007 14:51 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
This is an easy one. There is no file named ctrlstandby01.ctl in your directory where you are running sql loader.
Re: Having Problems with SQL Loader [message #266776 is a reply to message #266406] Tue, 11 September 2007 11:15 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Actually, I have my hard drive partitioned to C, E, and F. And I installed Oracle on E ... so, what do you think is the problem?

Thanks for your reply.

Cherish
Re: Having Problems with SQL Loader [message #266781 is a reply to message #266401] Tue, 11 September 2007 11:24 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
What part of "There is no file named ctrlstandby01.ctl in your directory where you are running sql loader." do you not understand?????
Re: Having Problems with SQL Loader [message #267228 is a reply to message #266781] Wed, 12 September 2007 14:34 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Every part of it. And that's why I'm asking again and trying to explain where my controlfile is.

Re: Having Problems with SQL Loader [message #267232 is a reply to message #267228] Wed, 12 September 2007 14:52 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
E:\>sqlldr pubs/pubs@standby control=ctrlstandby01.ctl

"E:\" suggests that you are running SQLLDR command when in root directory of drive E.

Error message ("Unable to open file (ctrlstandby01.ctl)") means that SQL*Loader executable was found, but it couldn't find the control file. The way you put it, it is expected that control file is also in the root directory of drive E.

What do
E:\> dir ctrlstandby01.ctl
E:\> dir *.ctl
say? Anything or nothing there?

What does search utility of your operating system say when you search for "ctrlstandby01.ctl" file?
Re: Having Problems with SQL Loader [message #267268 is a reply to message #267228] Wed, 12 September 2007 22:31 Go to previous message
Barbara Boehmer
Messages: 8636
Registered: November 2002
Location: California, USA
Senior Member
Another method of ensuring that everything is accessible is to do it all from SQL*Plus, as mentioned in my response to a recent thread on the same subject:


http://www.orafaq.com/forum/t/88678/43710/
Previous Topic: Is it possible to export a view
Next Topic: Export Command Related
Goto Forum:
  


Current Time: Fri Dec 09 04:18:44 CST 2016

Total time taken to generate the page: 0.12887 seconds