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 vote115 views1 answer
Sql auto_increment syntax
SQL
6 votes111 views2 answers
Mysqldump password in file
SQL
0 vote112 views1 answer
Mysql grant grant option
SQL
1 vote120 views1 answer
Oracle stop
SQL
0 vote122 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
0 vote119 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
16 votes124 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
12 votes104 views4 answers
Mysql get date difference in hours
SQL
19 votes111 views3 answers
How to change column type psql
SQL
11 votes181 views1 answer
Oracle insert from select
SQL