oracle how to check if index is in unusable state

STATUS column from DBA_INDEXES, DBA_IND_PARTITIONS and DBA_IND_SUBPARTITIONS.


https://forums.oracle.com/forums/thread.jspa?threadID=1088692