Re: sqlldr not recognizing a file without an extension on Solaris

From: John Hurley <>
Date: Fri, 19 Feb 2010 05:33:16 -0800 (PST)
Message-ID: <>

On Feb 18, 11:38 pm, z1hou1 <> wrote:


> Versions of db and o/s
> Oracle version
> Solaris 8
> At the moment, the file is presented the way it is and I would like to
> explore the possibility that sqlldr can recognize a file without a "."
> or an extension. If there is absolutely no way that sqlldr cannot
> recognize a file with an extension, or ends with a ".", I will
> certainly rename the file before processing again st sqlldr.
> Regards,
> z1hou1

With oracle 10.2 available you can treat the file as an external table and get the contents into the database.

Kinda/sorta like sqlldr ... Received on Fri Feb 19 2010 - 07:33:16 CST

Original text of this message