index2.sql

set pagesize 9999
column tablespace_name format a12 heading "Tablespace"
column table_name format a28
column index_name format a30
column index_type format a6 heading "IdxTyp"
break on tablespace_name skip 1 on table_name on index_type

select tablespace_name, table_name, index_name, index_type
from user_indexes
order by 1, 2, 4, 3
/