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

4 votes248 views3 answers
Count with where
SQL
2 votes247 views2 answers
Postgres set user as superuser
SQL
3 votes267 views1 answer
Select database in sql
SQL
0 vote265 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
-1 vote214 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote269 views1 answer
Changing name of column and datatype in sql
SQL
4 votes233 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
10 votes295 views6 answers
Mysql set root password
SQL
2 votes252 views2 answers
Sql query to copy data from one column to another
SQL
0 vote265 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL