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

34 votes165 views6 answers
Install mysql client ubuntu
SQL
0 vote166 views1 answer
When mysql server would not work in xampp
SQL
0 vote151 views1 answer
Template MySQL Zabbix agent
SQL
0 vote154 views2 answers
Sql query print strings and int
SQL
0 vote131 views1 answer
Mysql set column equal to another automatic
SQL
0 vote145 views2 answers
Greater than sql server
SQL
2 votes98 views1 answer
Foreign key example in dbms
SQL
3 votes163 views1 answer
What is having
SQL
0 vote140 views1 answer
Mysql create table like
SQL
0 vote139 views1 answer
St_buffer mysql
SQL