Why do I still see index partitions when I dropped the underlying table

From: <Cherie_Machler_at_gelco.com>
Date: Fri, 11 May 2001 10:36:24 -0700
Message-ID: <F001.0030115E.20010511091133@fatcity.com>

This one's got me stumped. We are on 8.0.4 on Sun Solaris 2.6.

I have some locally indexed partitions on a table that's partitioned by time. I dropped the '96 and '95 partitions of the underlying table and I no longer see them. I used the following statements:

alter table xx truncate partition 95 drop storage; alter table xx drop partition 95;

According to the documentation, the corresponding '95 and '96 index partitions (for a locally indexed table which I confirmed that it is using the LOCALITY column of dba_ind_partitions) should be dropped automatically. However, when I query dba_ind_partitions view, I can still see them.

Documentation says I can not specifically drop index partitions of locally indexed tables (can only do this for globally indexed tables). I actually tried to drop these partitions and Oracle gave me an error message saying I couldn't do it because it was a local index.

I thought these index partition 95 and 96 would go away. Why do I still see them? We will rebuild the index tonight but I can't rebuild the whole index right now - too much performance degredation.

I'm just curious about what is going on. Do I need to refresh something? Is there anything low-impact I can do right now to make these index partitions go away? Do I even need to care?

Thanks for any kind soul with answers.

Cherie Machler
Gelco Information Network

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Cherie_Machler_at_gelco.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri May 11 2001 - 12:36:24 CDT