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

1 vote189 views1 answer
Mysql select update same table
SQL
0 vote198 views1 answer
Transalations from sql to Linq count and group by
SQL
-1 vote121 views2 answers
On delete set default sql server
SQL
0 vote171 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote171 views1 answer
Psotgres multiple values
SQL
0 vote153 views1 answer
Mariadb set vertical output format
SQL
13 votes177 views4 answers
What is sql
SQL
8 votes141 views1 answer
Oracle current date plus 1 month
SQL
3 votes170 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
1 vote161 views1 answer
How to delete a record from sqlite in android
SQL