By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,574 Members | 3,021 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,574 IT Pros & Developers. It's quick & easy.

Urgent: SQL*LOADER ERROR 500 Unable to open file, file not found.

P: 2
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.


Now 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.


right now my control file location is 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. but no luck..!!!
I have tried giving the path in command too but no luck.

Could any one tell me what should be the location of my control file loader.ctl?

Thanks
Vishal
Sep 4 '07 #1
Share this Question
Share on Google+
5 Replies


debasisdas
Expert 5K+
P: 8,127
please specify the complete path of the file. in the controlfile name and alos the datafile
or

copy the control file to ......\bin\ folder in oracle home folder.

thi s will silve your problem.
Sep 5 '07 #2

P: 78
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.


Now 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.


right now my control file location is 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. but no luck..!!!
I have tried giving the path in command too but no luck.

Could any one tell me what should be the location of my control file loader.ctl?

Thanks
Vishal

hi friend,
pls you create log file and then u see the log file what exact error
occurs during the loading.........
Sep 5 '07 #3

P: 1
when I try from the Command Line The following sqlldr command

sqlldr scott/tiger@orcl D:\NEW\\ADCOLNA_PT_GRID

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.



how u have solved the problem?

can you guide me its urgent..

Thanks in advance
s prabhakar
Apr 24 '09 #4

P: 1
Check your source data. If any numeric field is null or blank that should be replaced by zero. Text file should be in default path.
Apr 14 '14 #5

P: 1
If you are using Windows environment, mostly when you save .txt files in other extensions, it will not save proper name as you've given.
For example: If you want to create test.ctl , behind the scene Windows will save it like test.ctl.038739283 which is not proper controlfile.

Solution:
Open the file
Save as "test.ctl" (put the name within "" in File name bar and save it).
Dec 15 '16 #6

Post your reply

Sign in to post your reply or Sign up for a free account.