Re: Batch insert data into oracle from text file.

From: Scarab <yw_at_lucent.com>
Date: Mon, 26 Dec 2005 13:25:59 +0800
Message-ID: <donusn$5um@netnews.net.lucent.com>

Thanks to all of your reply.

I really need to write an application to finish the importing work, and I wonder whether OCI can be used.
What are external tables in ORACKE mean? Thanks.

"Mladen Gogala" <gogala_at_sbcglobal.net> wrote in message news:pan.2005.12.22.18.03.47.339300_at_sbcglobal.net...
> On Thu, 22 Dec 2005 17:45:27 +0800, Scarab wrote:
>
> > Because I have about 3G files to import every day, so performance is
greatly
> > valued.
>
> If you can make directories where the files reside available to the
> database server (not always possible), you can use external tables.
> That is the best and the most inexpensive solution.
>
> --
> http://www.mgogala.com
>
Received on Sun Dec 25 2005 - 23:25:59 CST