oracle find unusable indexes

1SELECT OWNER, INDEX_NAME, NULL AS PARTITION_NAME, NULL AS SUBPARTITION_NAME, TABLESPACE_NAME
2FROM DBA_INDEXES
3WHERE STATUS = 'UNUSABLE'
4UNION ALL	-- Index partitions:
5SELECT INDEX_OWNER, INDEX_NAME, PARTITION_NAME, NULL AS SUBPARTITION_NAME, TABLESPACE_NAME
6FROM DBA_IND_PARTITIONS
7WHERE STATUS = 'UNUSABLE'
8UNION ALL	-- Index subpartitions:
9SELECT INDEX_OWNER, INDEX_NAME, PARTITION_NAME, SUBPARTITION_NAME, TABLESPACE_NAME
10FROM DBA_IND_SUBPARTITIONS
11WHERE STATUS = 'UNUSABLE';