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 vote201 views1 answer
Mysql coonect sample code
SQL
0 vote228 views1 answer
Pgadmin save data greyed out
SQL
0 vote248 views1 answer
How to subquey to do not load in live database in
SQL
8 votes251 views6 answers
Insert command in sql
SQL
0 vote184 views5 answers
Sql table intermédiaire
SQL
23 votes205 views4 answers
How to show all users in mysql
SQL
4 votes167 views2 answers
Select todays data postgres query
SQL
1 vote332 views1 answer
Concat first name and last name in mysql
SQL
1 vote209 views1 answer
Mariadb case switch
SQL
0 vote197 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL