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 votes315 views3 answers
Sqlite reset autoincrement
SQL
0 vote320 views1 answer
Sql server system messeges
SQL
17 votes313 views6 answers
Sql current date
SQL
0 vote359 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
2 votes334 views2 answers
Postgres drop column if exists
SQL
0 vote356 views1 answer
Sqlcl format
SQL
0 vote333 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote346 views2 answers
How to add CHECK constraint to a column in postgres
SQL
0 vote312 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote331 views1 answer
Select all columns except one sql
SQL