Hi I was inserting some date do my table. For some reasons I had to disable my constraint. The constraint was associated with index. I. ve used this line of code:
ALTER TABLE my_table DISABLE CONSTRAINT "my_constraint" drop index
And my_constraint is in disable state. No I' d like to enable this constraint, but after calling this line:
ALTER TABLE my_table ENABLE NOVALIDATE CONSTRAINT "my_constraint";
I recive an error:
See Question&Answers more detail:osORA-02299: cannot validate (USER.my_constraint) - - duplicate keys found