Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: refresh test from prod in wrong way

Re: refresh test from prod in wrong way

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 17 Oct 2006 21:01:38 +0100
Message-ID: <E8WdneFpM5kEq6jYnZ2dnUVZ8qudnZ2d@pipex.net>


soalvajavab1_at_yahoo.com wrote:
> in our company everytime they refresh the test from production, all the
> user accounts will be gone!
>
> what is the typical way of refreshing a test db from prod? How do you
> avoid this problem typically?
>

I'd look up database cloning in , for example, the rman docs. You may have other application specific issues just blindly duplicating databases along with user accounts, but RMAN will do tis for you.

-- 

Niall Litchfield
Oracle DBA
http://www.orawin.info/services/
Received on Tue Oct 17 2006 - 15:01:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US