title: Select all indexes of a type in Oracle
body: <p>How does one go about selecting all indexes of a specific type in Oracle 10g, for instance I want all of the <code>bitmap</code> indexes that are declared.  </p>
  
  <p>I imagine the query would be something like this:  </p>
  
  <pre><code>select * from system_indexes where type = 'bitmap'
  </code></pre>
  
  <p>but that is definitely not correct.</p>