Home » RDBMS Server » Server Utilities » sql *loader (Oracle, 10g, windows XP)
sql *loader [message #338219] Mon, 04 August 2008 04:15 Go to next message
jyothsna1612
Messages: 68
Registered: June 2008
Member
I'm sorry for the mistake...

My question is:
I tried working with sql*loader
I've given every thing correct
But getting the following error:

C:\>sqlldr userid=macjyo@testdb control='c:\exp.ctl'
Password:

SQL*Loader: Release 10.2.0.1.0 - Production on Mon Aug 4 14:40:48 2008

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

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

C:\>

What must be the reason for getting this error

[EDITED by LF: fixed "No message body" situation]

[Updated on: Mon, 04 August 2008 04:23] by Moderator

Report message to a moderator

Re: sql *loader [message #338221 is a reply to message #338219] Mon, 04 August 2008 04:19 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Quote:
What must be the reason for getting this error


Hmm what about
Quote:
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.
Re: sql *loader [message #338223 is a reply to message #338219] Mon, 04 August 2008 04:22 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
I've given every thing correct
But getting the following error:

Obviously, everything wasn't THAT correct.

Get used to read the manual: SQL*Loader.
Re: sql *loader [message #338226 is a reply to message #338219] Mon, 04 August 2008 04:30 Go to previous messageGo to next message
jyothsna1612
Messages: 68
Registered: June 2008
Member
I have changed saving the control file with double quotes instead of typing exp.ctl..

But again getting the error

C:\>sqlldr userid=macjyo control='c:\exp.ctl'
Password:

SQL*Loader: Release 10.2.0.1.0 - Production on Mon Aug 4 14:56:51 2008

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

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12560: TNS:protocol adapter error

C:\>
Re: sql *loader [message #338227 is a reply to message #338226] Mon, 04 August 2008 04:36 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You have forgotten the connection identifier on this line:
C:\>sqlldr userid=macjyo control='c:\exp.ctl'
Re: sql *loader [message #338230 is a reply to message #338227] Mon, 04 August 2008 04:48 Go to previous messageGo to next message
jyothsna1612
Messages: 68
Registered: June 2008
Member
I've given correctly...
I didn't miss any:

C:\>sqlldr userid=macjyo control='c:\exp.ctl'
Re: sql *loader [message #338236 is a reply to message #338230] Mon, 04 August 2008 05:14 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps you used invisible ink, but I don't see sqlldr userid=macjyo@testdb control= ...
Re: sql *loader [message #338248 is a reply to message #338236] Mon, 04 August 2008 05:39 Go to previous messageGo to next message
jyothsna1612
Messages: 68
Registered: June 2008
Member
Though

C:\>sqlldr macjyo/macjyo@testdb control='c:\exp.ctl'

SQL*Loader: Release 10.2.0.1.0 - Production on Mon Aug 4 15:19:35 2008

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

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

Re: sql *loader [message #338249 is a reply to message #338248] Mon, 04 August 2008 05:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Back to the start?

Regards
Michel
Re: sql *loader [message #338252 is a reply to message #338249] Mon, 04 August 2008 05:49 Go to previous messageGo to next message
jyothsna1612
Messages: 68
Registered: June 2008
Member
Hi michel,

My date file is
12, Research, "Saratoga"
10, "Accounting", Cleveland
11, "Art", Salem
13, Finance, Boston
21, Sales, Phila
22, Sales, Rochester
42, "Int'l", "San Fran"

Table:
CREATE TABLE testdept
(deptno NUMBER(2) NOT NULL,
 dname VARCHAR2(14),
 loc VARCHAR2(13));

Control file is
LOAD DATA
INFILE 'c:\exp.dat'
INTO TABLE testdept
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
(deptno, dname, loc)


Tried in cmd prompt, but getting the following error:
C:\>sqlldr macjyo/macjyo@testdb control='c:\exp.ctl'

SQL*Loader: Release 10.2.0.1.0 - Production on Mon Aug 4 15:19:35 2008

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

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







Re: sql *loader [message #338253 is a reply to message #338219] Mon, 04 August 2008 05:49 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Possibly it will be,
C:\>sqlldr macjyo/macjyo@testdb control='c:\exp.ctl.txt'
Re: sql *loader [message #338259 is a reply to message #338252] Mon, 04 August 2008 05:59 Go to previous message
jyothsna1612
Messages: 68
Registered: June 2008
Member
Hurray!
I got it...
The mistake is i saved control file as exp.ctl
and it stored as a text file..

Then again i resaved it with "exp.ctl"
Now working properly and data is stored into the table ...
Previous Topic: Error during Import
Next Topic: Creating Physical table by using External tables
Goto Forum:
  


Current Time: Sat Dec 10 16:51:56 CST 2016

Total time taken to generate the page: 0.07516 seconds