Re: Automatic import of a text file into an Oracle database

From: Tanel Poder <tanel_at_@peldik.com>
Date: Tue, 17 Jun 2003 18:13:48 +0300
Message-ID: <3eef3045_1@news.estpak.ee>

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:l2GHa.18715$pK2.26197_at_news.indigo.ie...
> With later versions of Oracle you can map a character file directly to an
> Oracle table
> (this is known as External Tables ) and you could then write a procedure
or
> other code to validate it and transfer it to whicheve tables you require.

With external tables you have a problem with bad and discardfiles. AFAIK, when selecting from external table, you don't know, if there were any bad or discarded rows. You have to have some external routine as well, which handles those.

Tanel. Received on Tue Jun 17 2003 - 10:13:48 CDT