Enable Novalidate a table constraint
I created a table with a unique constraint on one column DISABLED. I then proceeded to insert duplicate data in this field. When I try to ENABLE NOVALIDATE this constraint, I get the error ORA-02299: cannot validate (SCOTT.SARAH_U) - duplicate keys found. With the NOVALIDATE option, shouldn't it ignore existing records?
My statement was: alter table sarah enable novalidate unique (cd);
It seems as if the "novalidate" keyword is not being read.
Thanks for any help.