I have disabled the foreign key constraints.Inserted new rows in the table.but when i am trying to enable the constraint.
Error says that there is a constraint violation.
I do not want any rows to be deleted.And want the constraint to be enabled so that future inserted records are proper.
It can be done in 8 and 8i.I have done it long back and forgot the syntax.
alter table emp enable constraint fk_dept ...
the ending will be like validate ..
I want the correct syntax for that.
I think the command is
ALTER TABLE <table_name>
ENABLE NOVALIDATE CONSTRAINT <CONSTRAINT_NAME>
sorry something went wrong
ALTER TABLE table_name
ENABLE NOVALIDATE CONSTRAINT constraint_name
Click Here to Expand Forum to Full Width