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 vote212 views1 answer
Sql decode
SQL
4 votes188 views4 answers
Sqlite describe table
SQL
0 vote218 views1 answer
Mysql timediff
SQL
0 vote177 views1 answer
Opensuse stop MySQL
SQL
2 votes196 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
0 vote181 views1 answer
Get who is hired in specific month in sql
SQL
22 votes205 views3 answers
Remove all records from table mysql
SQL
2 votes228 views5 answers
Tablespace ORACLE
SQL
0 vote176 views1 answer
If exist column in table drop sql query mysql
SQL
0 vote191 views1 answer
Laravel eloquent get generated sql
SQL