Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: set constraints all immediate

Re: set constraints all immediate

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Wed, 28 Nov 2001 04:24:58 GMT
Message-ID: <uGZM7.40340$xS6.67456@www.newsranger.com> 





Hi,


when you commit the transaction which violates a deferred constraint, oracle
usually inform you with the name of constraint violated.
And if you have several constraints on a table, the rest ones will not be
enforced unless you get rid of the violated one.



Regards,



--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com


Received on Tue Nov 27 2001 - 22:24:58 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US