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

Thread: Questios about contraints (2)

  1. #1
    Join Date
    Oct 2001
    Posts
    22

    Question

    When defining constraints while creating a table, there are 4 defer specs:

    NOT DEFERRABLE | DEFERABLE | ININTIALLY {IMMEDIATE|DEFERRED}

    What I don't know is :

    1. Do I have to choose one out of them?

    2. It is said that a NOT DEFERRABLE constraint cannot be deffered by session or transaction. This means that once I choose the defer spec as NOT DEFERRABLE, then I cannot change the state by SET CONSTRAINT(S) command?

    Should have found out by practing it Oracle environment, but My PC is broken down and under repair , and I have to wait at least 10 days to get it back. :-( But I can't wait doing nothing, so I keep studying in this way. You might feel borthersome in some way. But I'll appreciate every bit of your help.

    Thanks in advance.

    Do not worry people not knowing you,
    but seek the way that truely make yourself known to them
    -Confucius
    Need an Oracle running on Mac OS !!
    aleaves@hitel.net

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

  3. #3
    Join Date
    Oct 2001
    Posts
    22

    one more question

    Thank you for the OTN link page. It helps me tangle out confusion about constraints. But I want to ask you one more question to clear my understanding about the article on the web reference.

    DEFERRABLE | NOT DEFERRABLE options mean that constraints can be set to DEFERRED | NOT DEFERRED by SET CONSTRAINT(S) ?
    So, initial constraint state is set by INITIALLY DEFERRED | INITIALLY IMMEDIATE , and if a constraint is set DEFFERABLE INITIALLY IMMEDIATE, it means that constraint is set INITIALLY IMMEDIATE, but can be changed to DEFFERABLE by SETTING CONSTRAINT(S) command ?

    Need your help on this.

    Thank you so much.

    Woo
    Do not worry people not knowing you,
    but seek the way that truely make yourself known to them
    -Confucius
    Need an Oracle running on Mac OS !!
    aleaves@hitel.net

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