I have indexes associated to a partitioned table. When I checked the status column of the
dba_indexes view, some of the indexes have their status as UNUSABLE. Can any body explain why?
I thought the status column from dba_ind_partition view is supposed to show that but not
dba_indexes.
Why am I getting UNUSABLE for partitoned indexes associated with a partitioned table
from dba_indexes?