Re: Inserting 28.8 Million records

From: Mabel TrigØis <mabelle_at_bluewin.ch>
Date: 1998/01/27
Message-ID: <01bd2ba1$5098c480$b60bbac3@m3bj1>#1/1

Hello:
Maybe the problem is in the process of your data before insertion. Can you try to process your data after loaded it in a working table?. Mabel,

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 Tue Jan 27 1998 - 00:00:00 CST