We copy the data from the production database. These data have already
been validated.
Then we recreate the constraint.
We want to create them in "enable novalidate" mode. Validation is very
long and we want to skip it.
On 2 avr, 19:08, "hpuxrac" <johnbhur..._at_sbcglobal.net> wrote:
> 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 - 15:37:10 CDT
