Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL*Loader-500: Unable to open file

Status
Not open for further replies.

goldenlam

MIS
Feb 28, 2000
12
US
I am trying to run a sql loader .ctl file from a .bat file.
The data file (.txt), the .ctl file are both in the same directory. The .ctl starts but then I get a .log file that reads the following error message:

SQL*Loader-500: Unable to open file (c:\narrative.txt)
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

If I put a path for the .txt, then the loader will run.

I was able to do this in other .bat files without specifying a path for the .txt so I would like to know why after reinstalling sqlldr73 and sqlldr80 on my machine, I now have to path the .txt.

Thanks
goldenhead
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top