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

1 vote325 views1 answer
Convert rows to string sql server
SQL
1 vote384 views2 answers
This month mysql where
SQL
23 votes314 views6 answers
Create table sql
SQL
0 vote330 views1 answer
Connect postgresql using a connection string
SQL
0 vote339 views1 answer
Run mssql server terminal
SQL
5 votes363 views4 answers
Start postgres server
SQL
0 vote386 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
7 votes389 views2 answers
Sql remove duplicates based on column
SQL
0 vote325 views1 answer
Linked server delete openquery
SQL
1 vote382 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL