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

[vshalpatel]

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

[debasisdas]

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.

[holdingbe]

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

[prabhakar123]

sqlldr error

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

[12549paul]

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.

[IffyKhan007]

Solution

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.038739 283 which is not proper controlfile.

Solution:
Open the file
Save as "test.ctl" (put the name within "" in File name bar and save it).