20TB Production to 80GB Test data with privacy in 10 minutes, Oracle

Share on facebook
Share on twitter
Share on linkedin

I have a huge production database and need only partial, secured data

Source production database is huge; 20TB that includes 100 tables and customer sensitive data.

For testing environment we need only a small part of the production database: 4 tables with relevant data from the last 3 months, 80GB. Considering privacy regulations, we also need to mask sensitive data.

Test data total generation time is 10 minutes.