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

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

Re: Why do I still see index partitions when I dropped the

Cherie, I take it that you built your indexes as create index xxx on table(col) local (partition x1 on tablespace 95, partition x2 on tablespace 96..) then you truncated the table in the partition 95 and then dropped the partition. If I remember correctly the index for the dropped partition

Re: Why do I still see index partitions when I dropped the

RROGERS@galoTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ttery.org cc: Sent by: Subject: Re: Why do I still see index