Re: Bulk Insert into ORACLE?

From: Don Gerhart <gerhart.don_at_mayo.edu>
Date: Wed, 28 Mar 2001 15:40:01 GMT
Message-ID: <3ac20566.178950687@mayonews>

On Tue, 27 Mar 2001 12:59:07 +0100, Charles McDonald <cmcdon12_at_nospam.ford.com> 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

Charles,

If you are doing a large batch load, you might want to turn logging off for any related indexes. This should help your performance.

Don Gerhart Received on Wed Mar 28 2001 - 09:40:01 CST