Re: Bulk Insert into ORACLE?

Charles McDonald wrote:

> Hello all
>
> I wonder if anyone could give me a pointer to bulk inserts into ORACLE.
>
> The situation currently is a fixed format flat file which is imported
> line by line via a VB app using an INSERT. This is very slow, since we
> have many files with a great deal of data... Some records need things
> added to each record such as ItemCodes which are not included in the
> flat file.
>
> Could anyone mention a few keywords which I could search on.
>
> Thanks Guys & Gals
>
> Charles

Hi Charles,
I'm not sure if it's appropriate, but are you aware of the SQL*Loader product from Oracle?

Documentation for it is available from Technet at:

http://technet.oracle.com/docs/index.htm

Good Luck,
Avi. Received on Wed Mar 28 2001 - 00:34:20 CST