sql *loader [message #338219] |
Mon, 04 August 2008 04:15 |
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 #338226 is a reply to message #338219] |
Mon, 04 August 2008 04:30 |
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 |
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 #338248 is a reply to message #338236] |
Mon, 04 August 2008 05:39 |
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 #338252 is a reply to message #338249] |
Mon, 04 August 2008 05:49 |
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 #338259 is a reply to message #338252] |
Mon, 04 August 2008 05:59 |
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 ...
|
|
|