Constraints

[omegamark]

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.

[nbiketi]

I think the command is

ALTER TABLE <table_name>
ENABLE NOVALIDATE CONSTRAINT <CONSTRAINT_NAME>

[nbiketi]

sorry something went wrong

command

ALTER TABLE table_name
ENABLE NOVALIDATE CONSTRAINT constraint_name

[omegamark]

Thanks