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 vote199 views1 answer
Delete all rows from table sqlite
SQL
1 vote245 views1 answer
Sysdate in sql
SQL
0 vote228 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote260 views1 answer
DATEDIFF minute postgres
SQL
0 vote227 views2 answers
Select limit ms sql
SQL
0 vote245 views1 answer
Postgresql concat string with separator
SQL
0 vote255 views1 answer
Copying query result to excel
SQL
3 votes235 views2 answers
Create schema postgres
SQL
0 vote229 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote240 views1 answer
Search In the Database using Text
SQL