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: constraint disable (no)validate

Re: constraint disable (no)validate

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 08 Feb 2005 14:14:18 +0100
Message-ID: <cuads1$ir8$1@news6.zwoll1.ov.home.nl>


vertigo wrote:
> Hello
> What is the difference between:
> CONSTAINT DISABLE VALIDATE and
> CONSTAINT DISABLE NOVALIDATE ?
>
> Does NOVALIDATE keeps indexes associated with constraint and VALIDATE
> remove them ? Are there any other differences ?
>
> Thanx
> Michal
>

Not all constraints have indexes.... And what does validation spell in your language?
Over here, it means that something is checked against known values to see if the possibility give is valid. Hence validate. Novalidate would mean don't go through the validation process.

More Oracle speak in the concept and SQL reference manuals, all to be found at docs.oracle.com

-- 
Regards,
Frank van Bortel
Received on Tue Feb 08 2005 - 07:14:18 CST

Original text of this message

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