primary key validation only on new rows?

[pando]

Originally posted by anujpathak

SQL> alter table aa enable constraint pk_1 ;
alter table aa enable constraint pk_1
*
ERROR at line 1:
ORA-02437: cannot validate (SCOTT.PK_1) - primary key violated
[Edited by anujpathak on 04-15-2002 at 07:14 AM]

Hmm I thought I mentioned use novalidate clause in my previous post... not that hard to read man just have a closer look