Re: Unusable indexes

From: Anurag Varma <avoracle_at_gmail.com>
Date: 15 Mar 2007 14:16:17 -0700
Message-ID: <1173993377.290826.63190@y80g2000hsf.googlegroups.com>

On Mar 15, 4:45 pm, saketkha..._at_gmail.com wrote:
> Hello,
>
> Can someone please tell me which table/column in the data dictionary
> to refer to, to determine if an index is unusable?
>
> I have a partitioned index which when set to unusable, doesn't seem to
> modify any value in the user_indexes table.
>
> Thank you
> Saket

desc user_ind_partitions all_ind_partitions dba_ind_partitions column status Received on Thu Mar 15 2007 - 16:16:17 CDT