SELECT * FROM user_constraints WHERE constraint_name = 'SYS_C003122';
SELECT * FROM user_cons_columns WHERE constraint_name = 'SYS_C003122';

SQL> create table brisime (id number);

Table created.

SQL> insert into brisime (id) values (1);

1 row created.

SQL> insert into brisime (id) values (2);

1 row created.

SQL> create unique index ui_b on brisime (id);

Index created.

SQL>
SQL> insert into brisime (id) values (1);
insert into brisime (id) values (1)
*
ERROR at line 1:
ORA-00001: unique constraint (SCOTT.UI_B) violated

SQL> select * from user_constraints where table_name = 'BRISIME';

no rows selected

SQL> select index_name, table_name, uniqueness from user_indexes where table_name = 'BRISIME';

INDEX_NAME                     TABLE_NAME                     UNIQUENES
------------------------------ ------------------------------ ---------
UI_B                           BRISIME                        UNIQUE

SQL>