Tuesday, September 22, 2009

ORA-02437: cannot validate - primary key violated - Stack Overflow

ORA-02437: cannot validate <name> - primary key violated - Stack Overflow:

SQL>@%ORACLE_HOME%\rdbms\admin\utlexpt1.sql

Table created.

SQL> ALTER TABLE MY_TABLE ADD CONSTRAINT PK_FOO PRIMARY KEY (MY_ID)
2 exceptions into exceptions
3 /