This is the basic syntax that is used to find out the indexes for a table in Oracle.
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
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