| SQL Loader Unable to open file error (2 Merged) [message #546909] |
Fri, 09 March 2012 22:45  |
 |
selasky1
Messages: 3
Registered: March 2012
Location: michigan
|
Junior Member |
|
|
Hopefully someone can help me. I am recieving errors when trying to load the control file. The errors are as follows:
SQL*Loader-500 Unable to open file (homework.ctl)
SQL*Loader-553 file not found
SQL*Loader-559 SYstem error: The system cannot find the file specified.
My control file is located directly in the C drive (C:\homework.ctl). The control file contains the following code:
LOAD DATA
INFILE 'c:\country.dat'
APPEND INTO TABLE homework
fields terminated by ',' optionally encloded by '"'
(country, month, day)
WHEN (month='April')
The command I am entering is:
sqlldr system/password control=homework.ctl
I've tried c:\homework.ctl, 'c:\homework.ctl', and placing the file in the BIN folder of Oracle.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: SQL Loader Unable to open file error [message #546918 is a reply to message #546915] |
Fri, 09 March 2012 23:26  |
 |
Barbara Boehmer
Messages: 9104
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
selasky1 wrote on Fri, 09 March 2012 21:12
How do I know if the BIN folder is the default folder?
If you did a standard installation, then that is the default. That is where the sqlldr file is. If you are running sqlldr from that directory, then it will look in that directory. However, if you are running it from some other directory, then it will look in that directory. It will look in other directories if you have them set in your path. If you are using SQL*Plus, running it from a shortcut, then you can check the shortcut properties to see what directory it starts in.
If you save the file from SQL*Plus and run sqlldr from SQL*Plus, using the HOST command, then you do not have to specify directories or worry about permissions. It makes it a lot easier.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
