Oracle-L: Re: Datafile with no extension using sqlldr

From: Stephen Andert <stephenandert_at_firsthealth.com>
Date: Sun, 29 Dec 2002 07:53:40 -0800
Message-ID: <F001.00523D87.20021229075340@fatcity.com>

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

>>> master_dba_at_hotmail.com 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: stephenandert_at_firsthealth.com

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: ListGuru_at_fatcity.com (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).

Received on Sun Dec 29 2002 - 09:53:40 CST