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 vote279 views1 answer
Update having mysql
SQL
1 vote281 views1 answer
Mysql check string don't have number
SQL
0 vote278 views1 answer
SQL SELECT-Klausel
SQL
1 vote263 views1 answer
Loading local data is disabled mysql
SQL
0 vote258 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
1 vote280 views2 answers
How to search date in sql query
SQL
3 votes267 views1 answer
Mssql remove column
SQL
0 vote269 views1 answer
Mysql query to add hours to column in table
SQL
0 vote259 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote281 views1 answer
T sql cursor tr
SQL