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 vote204 views1 answer
Tsql find procedure with name
SQL
7 votes198 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
27 votes200 views5 answers
Add column in table
SQL
0 vote187 views1 answer
Mysql insert into select with recursive
SQL
1 vote196 views1 answer
Apex select list ORA-20999
SQL
1 vote201 views2 answers
Login to mysql
SQL
0 vote193 views1 answer
Monthly Birthday SQL Query
SQL
4 votes567 views1 answer
Oracle show errors
SQL
0 vote185 views1 answer
Why mysql is used?
SQL
0 vote207 views1 answer
SQL Cut part string
SQL