Prev: Viewing a Table's Fragmentation
Next: Upgrade issue? Can't start/stop oracle if non dba started it
From: vertigo on 8 Feb 2005 04:48
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

From: Frank van Bortel on 8 Feb 2005 08:14
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
 | 
Pages: 1
Prev: Viewing a Table's Fragmentation
Next: Upgrade issue? Can't start/stop oracle if non dba started it