This is the basic syntax that is used to find out the indexes for a table in Oracle.
SELECT owner, index_name,tablespace_name, statusSet pagesBreak on table_name on index_namecolumn table_namecolumn index_namecolumn column_nameselect table_name, index_name, column_namefrom dba_ind_columnswhere table_ownerorder by table_name, index_namecolumn_position
SELECT owner, index_name,
tablespace_name, status
Set pages
Break on table_name on index_name
column table_name
column index_name
column column_name
select table_name, index_name, column_name
from dba_ind_columns
where table_owner
order by table_name, index_name
column_position