Re: Inserting 28.8 Million records

From: DanielM <Danielm_at_Sheraton.co.uk>
Date: 1998/01/28
Message-ID: <01bd2be7$7922b780$6954c8c2@pcdm>#1/1

I should think that using SQL*Loader would be a much faster way of inserting that sort of number or rows.

Probably the best way would be to load the data into work tables using SQL*Loader then process (using set based techniques) and insert from the work tables into your real tables.

Dan.

Unknown User <@cyberway.com.sg> wrote in article <34cd6b71.0_at_cwaix>...
> Hi,
> I am importing data into an Oracle database. With
> something like 28.8 million records. It took 4 days just to insert 1.5
> million records.
>
> Each table can be more than 11 to 15 million records.
>
> The importing through Pro*C programs are taking a long time.
>
> Are there alternatives because currently it takes too long? SQL*Loader?
I
> need to process data before insertion.
>
> Any optimization/configuration of rollback segments could be done??
>
> Mike
>
>
>
Received on Wed Jan 28 1998 - 00:00:00 CST