Re: refreshing from production

On Tue, 04 Sep 2001 18:38:46 GMT, "Terry Dykstra" <dontreply_tdykstra_at_cfol.ab.ca> wrote:

>Or delete the development database, copy over the production db and then use
>'backup control file to trace' to rename the copied database into develop.
>
>--

The backup/restore thing works, but it also copies all uids/pwds from production to development. It's advisable to have a step added that changes at least some passwords and disables most of the remaining production users.

Also, be aware that you're copying the *entire* production setup. Potentially, you are copying extensive rollback and tremporary tablespaces that support the full production load of users. For large loads of users (or large production databases), these two may be quite large. You may not require these in development. At the very least, you may end up with considerable wasted disk space.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Wed Sep 05 2001 - 05:40:28 CDT