select owner,index_name,index_type from all_indexes where owner='xxxx' and table_name='xxx'
select *from all_ind_columns where table_owner='xxx' and table_name='xx';