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 votes184 views3 answers
Stop mysql service ubuntu
SQL
0 vote191 views1 answer
Uncheck constraints and delete from table
SQL
0 vote190 views1 answer
Querry mysql by 2 columns
SQL
1 vote180 views1 answer
Mariadb alter user host
SQL
16 votes194 views3 answers
T-SQL Add Column
SQL
1 vote184 views1 answer
Add many column to sap iq table
SQL
1 vote227 views1 answer
Postgresql append array
SQL
2 votes203 views1 answer
Import large .sql files into lampp
SQL
50 votes248 views6 answers
Sql duplicate rows
SQL
0 vote177 views1 answer
Min mysql
SQL