Select all type indexes in Oracle

Question

How to make a selection of all indexes of a certain type in Oracle 10g, for example, I want all bitmap indexes to be declared.

I assume the query would be something like this:

 select * from system_indexes where type = 'bitmap' 

but this is definitely not true.

Answer 1

 SELECT * FROM dba_indexes WHERE index_type IN ('BITMAP', 'FUNCTION-BASED BITMAP' ) 

probably what you are looking for (although you may only need indexes where index_type = 'BITMAP' . If you are only interested in indexes on tables that you have SELECT access to, you can query all_indexes , not dba_indexes . If you are only interested indexes in the current schema, you can query user_indexes , not dba_indexes .