Help!! How to drop local index partition?

From: <drona_rom_at_my-deja.com>
Date: Thu, 13 Jan 2000 19:14:27 GMT
Message-ID: <85l863$da6$1@nnrp1.deja.com>

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. Received on Thu Jan 13 2000 - 13:14:27 CST