OraFAQ Forum: Server Utilities » unable to load data using SQLLDR

Home » RDBMS Server » Server Utilities » unable to load data using SQLLDR

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

unable to load data using SQLLDR [message #176328]

Wed, 07 June 2006 21:43

srvadlamudi7
Messages: 5
Registered: June 2006
Location: Australia

Junior Member

hai iam trying to load data usig sqlldr in windows. but iam getting the following error.

C:\>sqlldr hr/hr control="C:\Documents and Settings\Maddy1\Desktop\bookshelf.ctl"

LRM-00112: multiple values not allowed for parameter 'control'

SQL*Loader: Release 10.2.0.1.0 - Production on Thu Jun 8 12:25:35 2006

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

SQL*Loader-100: Syntax error on command-line

Report message to a moderator

Re: unable to load data using SQLLDR [message #176347 is a reply to message #176328]

Thu, 08 June 2006 01:01

Barbara Boehmer
Messages: 9101
Registered: November 2002
Location: California, USA

Senior Member

Use dir/x to find the short name of the documents and settings directory, like docume~1 and use that instead of the long name.

Report message to a moderator

Re: unable to load data using SQLLDR [message #176458 is a reply to message #176328]

Thu, 08 June 2006 06:34

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You may also want to try single-quotes ' around the path.

C:\>sqlldr hr/hr control='C:\Documents and Settings\Maddy1\Desktop\bookshelf.ctl'

Report message to a moderator

Re: unable to load data using SQLLDR [message #176759 is a reply to message #176328]

Fri, 09 June 2006 08:16

srvadlamudi7
Messages: 5
Registered: June 2006
Location: Australia

Junior Member

hi, i tried with those options but iam getting the following error. can any one please help me.

C:\>sqlldr hr/hr control='C:\DOCUME~1\Maddy1\Desktop\bookshelf.ctl'

SQL*Loader: Release 10.2.0.1.0 - Production on Fri Jun 9 23:13:43 2006

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

SQL*Loader-500: Unable to open file (C:\DOCUME~1\Maddy1\Desktop\bookshelf.ctl)
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.

Report message to a moderator

Re: unable to load data using SQLLDR [message #176816 is a reply to message #176759]

Fri, 09 June 2006 16:53

Barbara Boehmer
Messages: 9101
Registered: November 2002
Location: California, USA

Senior Member

You should only need to use one or the other, either the shorter name or single quotes, although both should work as well. Did you try it with the longer name and single quotes? Did you use dir/x on your operating system to find the short name? Docume~1 was just an example and it may be different on your system. It is usually the first 6 characters followed by a tilde followed by a number. If there are three such directories that start with the same letters Docume, then they would end in ~1 and ~2 and ~3. The operating system user must also have sufficient access to read and write to the file and directories.

Report message to a moderator

Re: unable to load data using SQLLDR [message #176821 is a reply to message #176328]

Fri, 09 June 2006 17:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Alternatively cd into the folder where bookshelf.ctl exists before invoking sqlldr control=bookshelf.ctl

Report message to a moderator

Re: unable to load data using SQLLDR [message #176891 is a reply to message #176821]

Sun, 11 June 2006 06:06

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

As Anacedant says, please check the filename.extension.
Most common mistake (when using notepad in windows) is the file would have been saved as 'bookshelf.ctl.txt' instead of 'bookshelf.ctl'.

Report message to a moderator

Re: unable to load data using SQLLDR [message #177372 is a reply to message #176891]

Wed, 14 June 2006 06:39

srvadlamudi7
Messages: 5
Registered: June 2006
Location: Australia

Junior Member

thanks friends. i found the mistake. iam not adding .txt at the end.
thnks for your reply.
srinivas.

Report message to a moderator

regarding OCP DBA 10g exam [message #181963 is a reply to message #176328]

Wed, 12 July 2006 06:41

srvadlamudi7
Messages: 5
Registered: June 2006
Location: Australia

Junior Member

hai,
i want to preapre for OCP DBA 10g. can any one suggest me the best books for that.
and i dont know any thing about the exam.i heard that OCA DBA 10g exam is prerequiste for the OCP is that true?can any one send me reply.
thanks
srinivas.

Report message to a moderator

Re: regarding OCP DBA 10g exam [message #181966 is a reply to message #181963]

Wed, 12 July 2006 06:45

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please post your question in training & certification forum

Report message to a moderator

Previous Topic:	SQL Loader - loading binary data fields
Next Topic:	how I import table and view into my current database aamir from mfa database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 08:28:00 CST 2024