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 -> Impact on changing an enabled validated constraint to enable novalidate ?

Impact on changing an enabled validated constraint to enable novalidate ?

From: <zejeanmi_at_gmail.com>
Date: 2 Apr 2007 08:14:48 -0700
Message-ID: <1175526888.604740.149610@q75g2000hsh.googlegroups.com> 





Hello,



We would like to change constraints that are enabled and validated to
"ENABLE NOVALIDATE" state.



I think that there is no problem doing that : any new line or update
will be checked thanks to the "ENABLE" state.
I feel that once validated there is no point in keeping the constraint
in "VALIDATE" state. "ENABLE NOVALIDATE" is sufficient.
VALIDATE seems only useful when we create a constraint on existing
data.



Am i right ?


Is there a (hidden) danger changing the constraint to NOVALIDATE ?



Thanks in advance



Jean-Michel
Received on Mon Apr 02 2007 - 10:14:48 CDT












Original text of this message













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