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 vote208 views1 answer
Scheduled mysql database backup in linux
SQL
6 votes158 views3 answers
Commit in sql
SQL
0 vote156 views1 answer
Rename view mysql
SQL
0 vote150 views1 answer
Sql select with apostrohpe
SQL
0 vote175 views2 answers
Sqlalchemy default value for column
SQL
7 votes156 views1 answer
Connect mysql docker
SQL
2 votes200 views2 answers
Null column to 0 in mysql
SQL
-1 vote138 views3 answers
Mysql get age from date
SQL
1 vote170 views1 answer
Mysql select for update ejemplo
SQL
1 vote156 views2 answers
How to drop a unique constraint in sql
SQL