|
-
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.
Radhakrishnan.M
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|