Re: Oracle multi Tb refresh for UAT from Prod

From: Upendra nerilla <nupendra_at_hotmail.com>
Date: Fri, 16 Nov 2018 16:57:51 +0000
Message-ID: <SN1PR10MB036876325714E2BF1F138F94D8DD0_at_SN1PR10MB0368.namprd10.prod.outlook.com>



Are you looking at any 3rd party products? If so, you may want to look into a product Delphix. It appears to be a candidate for what you are looking for. It can do data mask as well as refresh environments quickly. Tim Gorman is in the list - works for Delphix - reach out to him for any technical details..



From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Sanjay Mishra <dmarc-noreply_at_freelists.org> Sent: Friday, November 16, 2018 11:21 AM To: Oracle-L Freelists
Subject: Oracle multi Tb refresh for UAT from Prod

Can someone share the process used in your experience/organization where you have several multi TB database and need to frequently refresh UAT for performance testing ? I am looking not much from Masking the data which are sometimes required but based on dropping prod user and adding Test user and application schema back ? Appreciate If someone can share any script used for sync user/password which can be main challenge as other Registration with OEM/Catalog can be handled easily.

Tx
Sanjay

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 16 2018 - 17:57:51 CET

Original text of this message