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