Colunas indexadas (contidas em um índice)

select table_name, 
       index_name, 
       column_name, 
       column_position
  from dba_ind_columns
 where index_name = 'INDEX_NAME'
 order by index_name, column_position;

--alter INDEX_NAME pelo indice