Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Unusable indexes

Unusable indexes

From: <saketkhanna_at_gmail.com>
Date: 15 Mar 2007 13:45:14 -0700
Message-ID: <1173991514.805050.138870@y66g2000hsf.googlegroups.com>


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 Received on Thu Mar 15 2007 - 15:45:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US