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

3 votes153 views2 answers
Sql not contains
SQL
0 vote133 views1 answer
Gcloud check sql
SQL
0 vote188 views1 answer
Mysql collation portugues brasil
SQL
6 votes158 views2 answers
WHERE value IS sql
SQL
0 vote141 views1 answer
Insert using condition postgres
SQL
1 vote135 views2 answers
Postgresql backup and restore globals and data
SQL
0 vote164 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote130 views1 answer
Psql initialization
SQL
1 vote129 views1 answer
Pv mysql import
SQL
13 votes135 views3 answers
Insert mysql ifile nto database
SQL