Oracle find unusable indexes

SELECT OWNER, INDEX_NAME, NULL AS PARTITION_NAME, NULL AS SUBPARTITION_NAME, TABLESPACE_NAME
FROM DBA_INDEXES
WHERE STATUS = 'UNUSABLE'
UNION ALL	-- Index partitions:
SELECT INDEX_OWNER, INDEX_NAME, PARTITION_NAME, NULL AS SUBPARTITION_NAME, TABLESPACE_NAME
FROM DBA_IND_PARTITIONS
WHERE STATUS = 'UNUSABLE'
UNION ALL	-- Index subpartitions:
SELECT INDEX_OWNER, INDEX_NAME, PARTITION_NAME, SUBPARTITION_NAME, TABLESPACE_NAME
FROM DBA_IND_SUBPARTITIONS
WHERE STATUS = 'UNUSABLE';

Source: orafaq.com

Similar codes

0 vote147 views1 answer
SELECT statement to find the specific cell in database table
SQL
1 vote181 views1 answer
Oracle datafile max size 32gb
SQL
0 vote214 views1 answer
Drop check command
SQL
2 votes132 views1 answer
Express api ith mysql data
SQL
3 votes142 views1 answer
Where id is in list sql
SQL
0 vote195 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote140 views1 answer
Mysql check if lowercase
SQL
0 vote125 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
1 vote133 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote193 views2 answers
Wordpress change url in database
SQL