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 vote120 views1 answer
Mysql select all table that have field names
SQL
0 vote123 views1 answer
Assign value to var in SQL
SQL
3 votes213 views1 answer
Postgresql today - 1 year
SQL
0 vote122 views1 answer
Postgres copy command
SQL
0 vote126 views1 answer
Why mysql is used?
SQL
0 vote129 views1 answer
Sql value exists in column
SQL
0 vote136 views1 answer
What is top n result in sql
SQL
0 vote124 views1 answer
Sql server datetime to string
SQL
1 vote129 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
0 vote131 views1 answer
Html css mobile menu arrow dropdown
SQL