Re: Huge import takes a long time

Michael

On 7/22/05, Kline.Michael <Michael.Kline_at_suntrust.com> wrote:
> The bummer is, while they call it a month, they set the same date to all
> transactions. But there may be some other way to do this.
>

There has to be some criteria you can use to reduce the partition size.

> The index is partitioned, and it seems that ONLY that index partition is
> getting hit as it is in a separate tablespace.
>

We know inserts with a partition present take longer. This is proven. I'm suggesting you find a way to avoid inserting into the index, like direct path load into a separate table, build the index, then use exchange partition to swap it into the large partitioned table. Many people have saved enormous amounts of time with a scheme like this.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l