Tag Archives: indexes

Display All The Oracle Indexes In The Database

 

Display All Oracle Indexes in the database.  Shows all indexes.   Customize for your database.

set lines 200
set pages 200
Select owner, index_name, table_type, tablespace_name 
From dba_indexes 
where owner not in ('SYSTEM','DBSNMP','ORDSYS','OUTLN','SYS') 
order by owner, index_name, tablespace_name
;