Friday, July 30, 2010

SQL*Loader-500: Unable to open file

Problem.
In Command Line:
sqlldr user/pswd control=****.ctl direct=y log=****.log

If you get, error:
SQL*Loader 500-unable to open file (****.ctl)
SQL*Loader 553-file not found
SQL*Loader 509-system error, unable to locate specified file.

1) Check the location or right file name you are giving;

2) Can be space in the path clause.

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

2 comments: