Re: How do you refresh your databases?

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Thu, 24 Mar 2011 11:00:10 +0200
Message-id: <4D8B081A.90906_at_inter.net.il>



I would use datapump, over dblink, with exclude for the tables.

I use this method to move schemas to new databases on new servers and it works fine.

Yechiel Adar
Israel

On 22/03/2011 22:00, Guillermo Alan Bort wrote:
> List,
>
> We have to refresh a QA database from production (to have some real
> data) but we need to exclude all the PCI/PII from the refresh (it
> absolutely cannot be copied from Prod to QA). In addition, we have GG
> replication on Prod so anything we do is subject to that.
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 24 2011 - 04:00:10 CDT

Original text of this message