OraFAQ Forum: Server Utilities » Having Problems with SQL Loader

Home » RDBMS Server » Server Utilities » Having Problems with SQL Loader

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

Having Problems with SQL Loader [message #266401]

Mon, 10 September 2007 14:25

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

Report message to a moderator

Re: Having Problems with SQL Loader [message #266406 is a reply to message #266401]

Mon, 10 September 2007 14:51

joy_division
Messages: 4963
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.

Report message to a moderator

Re: Having Problems with SQL Loader [message #266776 is a reply to message #266406]

Tue, 11 September 2007 11:15

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

Report message to a moderator

Re: Having Problems with SQL Loader [message #266781 is a reply to message #266401]

Tue, 11 September 2007 11:24

BlackSwan
Messages: 26766
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?????

Report message to a moderator

Re: Having Problems with SQL Loader [message #267228 is a reply to message #266781]

Wed, 12 September 2007 14:34

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.

Report message to a moderator

Re: Having Problems with SQL Loader [message #267232 is a reply to message #267228]

Wed, 12 September 2007 14:52

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: Having Problems with SQL Loader [message #267268 is a reply to message #267228]

Wed, 12 September 2007 22:31

Barbara Boehmer
Messages: 9101
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/

Report message to a moderator

Previous Topic:	Is it possible to export a view
Next Topic:	Export Command Related

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 09:55:45 CST 2024