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

4 votes348 views4 answers
Pl sql output
SQL
1 vote368 views1 answer
Sql headers delphi
SQL
6 votes375 views2 answers
Mysql execute file
SQL
58 votes653 views6 answers
Create new user in postgres
SQL
0 vote382 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote380 views1 answer
Querry mysql by 2 columns
SQL
0 vote337 views1 answer
Sql change date format
SQL
4 votes338 views1 answer
Delete record mysql query
SQL
0 vote354 views1 answer
Mysql date time string format for marshmellow field schema
SQL
0 vote356 views1 answer
Sql menampilkan data tabel
SQL