Krishna, Have you tried putting a . at the end of your file name when calling sqlldr? Or can you rename the file to be emp.dat at the os level?
Stephen >>> [EMAIL PROTECTED] 12/28/02 09:13PM >>> Hi, Oracle 8.1.7 on SUN Solaris 5.8 I want to load a datafile with no extension into Oracle using SQL*Loader. But it looks for a file with a .dat extension. This is the exact error message I got: SQL*Loader-500: Unable to open file (emp.dat) SQL*Loader-553: file not found SQL*Loader-509: System error: The system cannot find the file specified. I have tried a number of ways but in vain. I understand I can rename the file. But, is there any other way to load a datafile with no extension? TIA, Krishna -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
