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 vote212 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote196 views1 answer
Sql ignore
SQL
0 vote179 views1 answer
Mysql identified by syntax error
SQL
0 vote179 views2 answers
Mysql two column combination unique
SQL
0 vote190 views1 answer
Sql datediff month
SQL
0 vote182 views3 answers
Get free card roblox
SQL
0 vote195 views1 answer
Alter check command
SQL
0 vote216 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote183 views1 answer
Sql case when exists in another table
SQL
3 votes185 views2 answers
Plsql print
SQL