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 vote105 views1 answer
Mysql milliseconds
SQL
1 vote114 views1 answer
Full sql mode
SQL
23 votes96 views6 answers
How to create table in sql
SQL
2 votes103 views2 answers
Install sqlalchemy
SQL
0 vote120 views1 answer
Mysql aspas simples
SQL
0 vote106 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
0 vote104 views1 answer
Authentication modes in sql server
SQL
0 vote112 views1 answer
Php get closest location by latitude longitude
SQL
1 vote115 views1 answer
Sql first day quarter
SQL
1 vote114 views1 answer
Mysql change root mysql_native_password
SQL