Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Impact on changing an enabled validated constraint to enable novalidate ?
On Apr 2, 11:45 am, zejea..._at_gmail.com wrote:
> Hello,
>
> The gain is not on the main database.
>
> We make an export data=no and retrieve the script to refresh other
> environments every day. (import data + rebuild index & contraint
> later)
>
> Having the constraint validated in the production environment, we
> retrieve a script with "VALIDATE" and so our "refresh" validates data
> coming from production that have been already validated. (and it's
> pretty long to validate again)
>
> I hope i've been understandable.
>
> Thanks
>
> JM
Then maybe you don't need the constraints at all? Or maybe they can be disabled.
But the question I go back to is if you have an actual problem you are trying to solve? Are the refreshes going slower because of the state of your constraints? Received on Mon Apr 02 2007 - 12:08:55 CDT