Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    16

    Unanswered: Alter constraint to deffered

    I would like to alter a FK constraint to be "deferrable initially deferred". I've looked on web for an "alter table"-script to accomplish this, without success. Does anybody here know how to do this without dropping the constraint and re-creating it again?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Alter constraint to deffered

    You cannot - quote from Oracle docs:
    You cannot alter a constraint's deferrability. That is, whether you specify either of these parameters, or make the constraint NOT DEFERRABLE implicitly by specifying neither of them, you cannot specify this clause in an ALTER TABLE statement. You must drop the constraint and re-create it.
    Details here:
    http://technet.oracle.com/docs/produ...s3a.htm#998196

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •