| SQL*LOADER ERROR 500 Unable to open File , File not found [message #264866] |
Tue, 04 September 2007 18:47  |
vshalpatel
Messages: 5
Registered: September 2007
|
Junior Member |
|
|
Hi
I want to use SQL*Loader , an Oracle-supplied utility to load data from a flat file into one database tables.
for this I have write the scripts in the SQL*LOADER control file named loader.ctl. actual data file is mydata.csv that I have mentioned under �load data� section in loader.ctl .
P.N : I am using my personal oracle installed on windows Pc. not using any n/w resources to access oracle DB
Now I know we need to invoke SQL*Loader (from command line) and point it to the control file describing the data in order to initiate this load.
my control file location is c:\loader.ctl. when I try from the Command Line The following sqlldr command
sqlldr scott/tiger control= loader.ctl
it gives me following errors
sql*loader error 500 unable to open file
sql*loader eroor 553 file not found
sql*loader error 509 the system can not find specified file.
i also tried by giving the absolute path of the control file
sqlldr scott/tiger control=c:\loader.ctl
(but the command cant locate it)
I even tried placing it in c:\oracle and few other different folder under oracle folder and I have tried mentioning the absolute path of the control file in command too but no luck.
could any one throw some light what could Could go wrong? any one tell me what should be the location of my control file loader.ctl?
Thanks
Vishal
[mod-edit] removedthe word URGENT from the title. No one wants it.
[Updated on: Wed, 05 September 2007 08:19] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: SQL*LOADER ERROR 500 Unable to open File , File not found [message #265183 is a reply to message #264866] |
Wed, 05 September 2007 12:12  |
 |
Barbara Boehmer
Messages: 9086
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
I find that one of the simplest ways to run it and figure out where it should be is to do everything from SQL*Plus. So, from SQL*Plus:
SQL> EDIT loader.ctl
and copy and paste your control file, then save it. Then, again from SQL*Plus:
SQL> EDIT mydata.csv
and copy and paste your data into it, then save it. Then, again from SQL*Plus:
SQL> HOST sqlldr scott/tiger control=loader.ctl log=loader.log
Notice that there is no space on either side of the equal sign in "control=loader.ctl". This is a requirement and may be your only problem. You can then, again from SQL*Plus:
SQL> EDIT loader.log
to see what happened during the load.
By doing things in this manner, you ensure that everything is in the right place and Oracle has rights to it. Sometimes saving things from the operating system may put it in the right place, but without sufficient access rights. When you are done, you can then check your operating system directories and see where it all landed.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
