ALTER TABLE EMP ENABLE NOVALIDATE PRIMARY KEY
13885Sep 9 2003 — edited Sep 9 2003INITIALLY I DISABLED THE PRIMARY KEY OF THE TABLE EMP THRO THE STATEMENT
ALTER TABLE EMP DISABLE PRIMARY KEY;
Table altered
I INSERTED SOME DUPLICATE RECORDS WITH PRIMARY KEY DISABLED.AFTER THAT I ENBALE THE PRIMARY KEY AS FOLLOWS.
ALTER TABLE EMP ENABLE NOVALIDATE PRIMARY KEY;
*
ERROR at line 1:
ORA-02437: cannot validate (PK_EMP) - primary key violated
eventhough i give a novalidate directive it throws me the above error(primary key violated).
HOW CAN I REINSTATE MY PRIMARY KEY WITH ALL MY DUPLICATE RECORDS INTACT (ENABLE ,NOVALIDATE).
PLEASE SUGGEST HOW THIS COULD BE DONE
THANX