Re: Help!! How to drop local index partition?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 16 Jan 2000 19:48:35 +0800
Message-ID: <3881B013.2DBE@yahoo.com>

drona_rom_at_my-deja.com wrote:
>
> Hello
> I have table with 8 partitions. I have built a local index with 8
> partitions. End of 8th day I need to drop the 1st partition and
> re-build it with new range of values. How do I drop the associated
> index. If I don't drop then loading might slow down rihgt ? Once I drop
> how do I re-build ? I deal with call volumes greater than 3
> millions/day.
> Any help?
> Thanks
> Drona
>
> e-g create table with partition table1, table2
> create index table_i on table (<column1>
> local
> partition table1 tablespace....,
> partition table2 tablespace ......,
>
> Once I drop table partition table1 what happens to the status of index
> partition table1 ? Once I rebuild the partition with new range, hwo do I
> build the index ?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

The beauty of local indexes is that this is down for you...Drop a partition, and the local index goes with with it. Add a new partition, and the local index gets a new partition as well...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sun Jan 16 2000 - 05:48:35 CST