Dropping Large Indexes

From: Anand Rao <panandrao_at_gmail.com>
Date: Mon, 28 Aug 2006 07:29:39 +0530
Message-ID: <d70710370608271859q258373c3y70449637bbdfd22c@mail.gmail.com>

Hi,

we all know to build large indexes using many fast methods like parallel, nologging, etc.

how can i speed up dropping large local index partitions with sizes exceeding 400GB? it takes a couple of hours on a 64-CPU IBM p595 box. that's too much lost for me.

the mark index 'unsuable' trick doesn't help as my inserts/updates would fail.

since it is not an index supporting a PK, i was thinking of dropping only the index partition that i don't want (leaving the table partition intact). i could later on build the index partition after the data load.

is that the only "fast" method?

thanks in advance,

regards
anand

---

All I need to make a comedy is a park, a policeman and a pretty girl - Charlie Chaplin

--

http://www.freelists.org/webpage/oracle-l Received on Sun Aug 27 2006 - 20:59:39 CDT