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

2 votes279 views1 answer
Remove foreign key constraints in postgres
SQL
4 votes233 views2 answers
Show all database inside postgresql
SQL
0 vote250 views1 answer
Hour differeence in mysql
SQL
0 vote223 views1 answer
Jooq replace
SQL
27 votes238 views3 answers
Mysql show tables in database
SQL
0 vote221 views1 answer
Sql get table last modified time
SQL
0 vote236 views1 answer
Mariadb disable foreign key checks
SQL
0 vote236 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote241 views1 answer
Sql filter rows with condition
SQL
1 vote234 views1 answer
Date_part mysql
SQL