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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
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