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

1 vote175 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
0 vote174 views1 answer
Difference between db.query and db.execute
SQL
1 vote167 views1 answer
Show all event schedular on mysql
SQL
0 vote165 views1 answer
Mysql autoincrement valor inicial
SQL
1 vote172 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote191 views1 answer
Oracle dynamic select into
SQL
1 vote172 views1 answer
How to delete a record from sqlite in android
SQL
0 vote175 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote138 views1 answer
CREATE MULTIPLE FK
SQL
4 votes162 views2 answers
Sql select except null
SQL