ORA-02299 Error

Adding a unique attribute to a field on a database table already in use will cause an error: ORA-02299.

Sql> CREATE index Uaccount_inx on Userss (Uaccount);

Index created

Sql> ALTER TABLE USERSS add constraint Uaccount_unique (uaccount) enable novalidate;

ALTER TABLE USERSS add constraint Uaccount_unique (uaccount) Enable Novalidate

ORA-00904:: Invalid identifier

Sql> ALTER TABLE USERSS add constraint uaccount_unique unique (uaccount) enable novalidate;

Table Altered

Sql> commit;

Commit Complete

Use the command above to resolve the problem.

ORA-02299 Error