How can I find Table, Index and Column which are indexed? : Oracle FAQ - dbapool.com

select index_name , table_name , column_name from user_ind_columns order by table_name ;