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 vote271 views1 answer
Sqlserver now
SQL
0 vote275 views1 answer
Postgres truncate with cascade
SQL
1 vote270 views1 answer
Sql only five first row
SQL
1 vote316 views1 answer
Sqlalchemy on delete set null
SQL
0 vote299 views1 answer
Call scalar valued function sql
SQL
0 vote270 views1 answer
If null don't update
SQL
3 votes300 views2 answers
Sql server current date without time
SQL
0 vote294 views1 answer
Sort by
SQL
0 vote315 views1 answer
How to find sql server installation folder
SQL
0 vote319 views1 answer
Python sqlalchemy connection show server
SQL