Re: Constraint Question - Deferred or Not Deferred?

<art_at_chicagorsvp.com> a écrit dans le message de news: 1132173818.582044.315510_at_z14g2000cwz.googlegroups.com...
| Hi,
|
| I am having trouble understanding the following states of a constraint:
|
| Initially Immediate
| Initially Deferred
| NoValidate
|
| >From my understandings, Initially Immediate means check the constraint
| as soon as the user hits enter. Initially Deferred means to check the
| constraint when the user types commit.
|
| Novalidate, I think, means not to check the data in the table. From
| what I have read, when a constraint is 'Novalidate', it creates a
| non-unique index, I assume to keep track of what was in the table?
|
| If I have a disabled constraint and want to enable it and not check
| what is in the table, can I alter the constraint to Novalidate?
|
| I also heard of a Reply and NoReply state, which I have not read about
| yet.....
|
| Thanks.
|

I can't say more that what's in the manual: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/clauses3a.htm#1002274

Regards
Michel Cadot Received on Wed Nov 16 2005 - 15:26:10 CST