select * from ALL_INDEXES where owner = 'xxx'and table_name = 'yyy';
select distinct index_owner,table_name,COLUMN_NAME from ALL_IND_COLUMNS where index_owner = 'xxx' and table_name = 'yyy';