Re: Bulk Insert into ORACLE?

Have you tried direct loades with SQL Loader. Direct Loads bypass the SQL+ layer.

Don Gerhart wrote:

> 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 - 13:45:15 CST