Re: Impact on changing an enabled validated constraint to enable novalidate ?

The various "alter table ... enable constraint" take 3 hours. Oracle really runs queries to validate the data.

We want to replace them with "enable novalidate".

On Apr 2, 11:31 pm, DA Morgan <damor..._at_psoug.org> wrote:
> zejea..._at_gmail.com wrote:
> > Validation is very long and we want to skip it.
>
> How have you determined this?
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Received on Tue Apr 03 2007 - 01:42:41 CDT