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

9 votes125 views6 answers
Check constraint in sql
SQL
1 vote108 views1 answer
Index a database column sql
SQL
1 vote106 views1 answer
Mysqli connect
SQL
6 votes125 views4 answers
Mysql group by month
SQL
3 votes121 views2 answers
Oracle apex charging debug
SQL
0 vote117 views1 answer
Sql query to return field name of a table
SQL
0 vote121 views1 answer
Rename constraint postgresql
SQL
-1 vote120 views1 answer
Sql add column bit
SQL
-1 vote110 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
1 vote112 views1 answer
Error code 1055
SQL