Re: Datafile with no extension using sqlldr

2002-12-29 Thread Stephen Andert
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

Re: Datafile with no extension using sqlldr

2002-12-29 Thread Yechiel Adar
infile 'abcd.' Yechiel AdarMehish - Original Message - From: Krishna Kakatur To: Multiple recipients of list ORACLE-L Sent: Sunday, December 29, 2002 6:13 AM Subject: Datafile with no extension using sqlldr Hi, Oracle 8.1.7 on SUN Solaris 5.8 I

Datafile with no extension using sqlldr

2002-12-28 Thread Krishna Kakatur
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 foundSQL*Loader-509: