Home » RDBMS Server » Server Utilities » Getting Error In SQL Loader
Getting Error In SQL Loader [message #327946] Wed, 18 June 2008 07:30 Go to next message
ramya29p
Messages: 146
Registered: November 2007
Location: Chennai
Senior Member
Hi I am Trying to load Flat file through SQL Loader But I am getting the Following Error

C:\Documents and Settings\RamyaP>sqlldr scott/tiger@orcl control=load1.ctl

SQL*Loader: Release 10.2.0.1.0 - Production on Wed Jun 18 17:34:22 2008

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

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

C:\Documents and Settings\RamyaP>
Re: Getting Error In SQL Loader [message #327949 is a reply to message #327946] Wed, 18 June 2008 07:33 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
This one is quite obvious. There is no file named load1.ctl in your directory.
Re: Getting Error In SQL Loader [message #328138 is a reply to message #327949] Thu, 19 June 2008 01:46 Go to previous messageGo to next message
shahnirav86
Messages: 13
Registered: June 2008
Location: anand,gujarat
Junior Member

can you give me exact code in more detail.
Re: Getting Error In SQL Loader [message #328155 is a reply to message #328138] Thu, 19 June 2008 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The "code" is correct, the file name or path is not, so only YOU know which one it is.

Regards
Michel

[Updated on: Thu, 19 June 2008 02:41]

Report message to a moderator

Re: Getting Error In SQL Loader [message #328207 is a reply to message #328138] Thu, 19 June 2008 06:36 Go to previous message
Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
shahnirav86
can you give me exact code in more detail.


SQL*Loader
The system cannot find the file specified.

What details do you need? The file simply isn't there!

(It *may* be in some directory on a disk, but not where SQL*Loader searches for it)
Previous Topic: Export error
Next Topic: Import file to DB
Goto Forum:
  


Current Time: Fri May 17 06:27:44 CDT 2024