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 vote308 views1 answer
MySQL FIND_IN_SET()
SQL
1 vote344 views1 answer
Postgres set sequence value to max id
SQL
13 votes318 views4 answers
Mysql select last 10 rows
SQL
7 votes342 views4 answers
Mysql delete older duplicates
SQL
1 vote349 views2 answers
Postgres select from last 3 months
SQL
0 vote426 views1 answer
Run docker container with database as rds metabase
SQL
0 vote322 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
18 votes340 views6 answers
Creating table in MySQL
SQL
1 vote357 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
2 votes336 views2 answers
How to rename column name in sql server using query
SQL