Re: sqlldr not recognizing a file without an extension on Solaris
From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Fri, 19 Feb 2010 05:33:16 -0800 (PST)
Message-ID: <b8ab3bce-ee19-464b-a59f-a7175008b052_at_a18g2000yqc.googlegroups.com>
On Feb 18, 11:38 pm, z1hou1 <z1h..._at_gmail.com> wrote:
Date: Fri, 19 Feb 2010 05:33:16 -0800 (PST)
Message-ID: <b8ab3bce-ee19-464b-a59f-a7175008b052_at_a18g2000yqc.googlegroups.com>
On Feb 18, 11:38 pm, z1hou1 <z1h..._at_gmail.com> wrote:
snip
> Versions of db and o/s
> Oracle version 10.2.0.4
> 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