Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: data load into partition table
This sounds great if there isn't any data existing in the partition before the load.
What if there is?
Bill Sonia
Achaia Solutions, Inc
In article <978473689.24411.0.nnrp-07.9e984b29_at_news.demon.co.uk>,
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> 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/
>
>
Sent via Deja.com
http://www.deja.com/
Received on Tue Jan 02 2001 - 17:00:06 CST