How do I drop and create just one local partition index?

I have a large table (for me anyway), 20 million rows that is partitioned by date and we drop all indexes, delete and reinsert about a million rows a night, but of the 24 monthly partitions, 99% of the activity is in the last 3 months (and partitions). Is there a way I can just drop the indexes on just those partitions. The indexes are a mix of local and global. I'm assuming I can only do this for the local ones.

Would making the indexes unusable and rebuilding them also be better than drop/recreate?

Thanks in advance. Received on Mon Nov 24 2003 - 13:48:07 CST