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
