Re: data load into partition table

One standard approach if you have the data for a single partition at a time is to create a spare table - load the table, index the table, then exchange the table with the partition (there are notes on my web-site).

Check the SQL ref manual for:

    Alter table XXX exchange partition ppp with table TTT     including indexes
    without validation

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



bsonia_at_my-deja.com wrote in message <92tiit$kt1$1_at_nnrp1.deja.com>...


>Hello,

>

>I have a 2 Billion row table that is divided into 104 partitions.  This

>table has 2 local indexes.  I would like to load data into a partition

>as fast as possible using sql-loader.  I can load the data fast after

>dropping the indexes on the entire table, but, the indexes take roughly

>24 hours to re-create which is too long.  I also tried to alter the

>index partition to make it unusable but this would cause an error

>before the load finished.

>

>Is there a way I can avoid the index overhead during a partition load

>and then rebuild it after the load is complete?

>

>Thanks,

>

>Bill Sonia

>Achaia Solutions, Inc

>

>

>Sent via Deja.com

>http://www.deja.com/