Unique Constraint of oracle (user_indexes and user_ind_columns )
The tables: user_indexes and user_ind_columns desc user_indexes; desc user_ind_columns; select * from user_indexes where table_name=upper('table name'); select * from user_ind_columns where index_name=upper('&index_name');