Constraints
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Constraints

  1. #1
    Join Date
    Sep 2000
    Posts
    384
    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

  2. #2
    Join Date
    Sep 2000
    Posts
    33
    I think the command is

    ALTER TABLE <table_name>
    ENABLE NOVALIDATE CONSTRAINT <CONSTRAINT_NAME>

  3. #3
    Join Date
    Sep 2000
    Posts
    33
    sorry something went wrong

    command

    ALTER TABLE table_name
    ENABLE NOVALIDATE CONSTRAINT constraint_name

  4. #4
    Join Date
    Sep 2000
    Posts
    384
    Thanks
    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
  •  


Click Here to Expand Forum to Full Width