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 votes210 views1 answer
Set default today mysql
SQL
0 vote171 views1 answer
Convert .mdf to .bak
SQL
0 vote223 views1 answer
Mysql show foreign keys column
SQL
2 votes197 views1 answer
Oracle trace file
SQL
0 vote176 views1 answer
Left join vs inner join performance
SQL
0 vote190 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
0 vote170 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote187 views1 answer
Postegresql update to null
SQL
0 vote193 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote193 views1 answer
Safe mysql
SQL