Getting Error In SQL Loader [message #327946] |
Wed, 18 June 2008 07:30 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #328207 is a reply to message #328138] |
Thu, 19 June 2008 06:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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)
|
|
|