VER INDICES DE UNA TABLA

select index_owner,table_owner,

index_name,

substr(column_name, 1, 30) column_name

from dba_ind_columns

where index_owner='SYSADM'

and table_name = upper('PSAPMSGPUBHDR')

order by table_owner, index_name;

select owner,table_name,index_name,tablespace_name from dba_indexes

where owner='SYSADM'

and table_name='PSAPMSGPUBHDR'

order by owner,index_name;