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 vote142 views1 answer
Postgresql create table many-to-many
SQL
1 vote165 views1 answer
Spark sql convert string to date
SQL
13 votes153 views3 answers
Insert mysql ifile nto database
SQL
3 votes144 views4 answers
Stop MySQL
SQL
0 vote142 views1 answer
Mariadb number format
SQL
0 vote147 views1 answer
Inserted row count tsql
SQL
5 votes130 views2 answers
Oracle list columns schema
SQL
0 vote155 views1 answer
Grant owner postgresql
SQL
12 votes174 views1 answer
Create column sql server
SQL
5 votes181 views1 answer
Migrate sql table another database
SQL