Oracle Database - Get unique indexes of a table
Here is a snippet to get the list of unique indexes of a particular table.
select c.*
from ALL_INDEXES i, ALL_IND_COLUMNS c
where
i.table_name = c.table_name
and i.table_owner = c.table_owner
and i.table_owner = 'THE_TABLE_OWNER'
and i.table_name = 'YOUR_TABLE'
and i.uniqueness = 'UNIQUE';
order by c.INDEX_NAME, c.TABLE_NAME, c.COLUMN_NAME;
Tested with Oracle Database 12.1