-
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
-
I think the command is
ALTER TABLE <table_name>
ENABLE NOVALIDATE CONSTRAINT <CONSTRAINT_NAME>
-
sorry something went wrong
command
ALTER TABLE table_name
ENABLE NOVALIDATE CONSTRAINT constraint_name
-
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
|