When production data is copied into a testing environment, there is the risk of breaching sensitive information to non-production users, such as application developers or external consultants. In order to perform real-world testing, these non-production users need to access some of the original data, but not all the data, especially when the information is deemed confidential.
Oracle Database offers test data management features that help reduce this risk by enabling you to:
Store the list of applications, tables, and relationships between table columns using Application Data Modeling
Replicate information that pertains only to a particular site using data subsetting
Replace sensitive data from your production system with fictitious data that can be used during testing using Oracle Data Masking
Test Data Management for information about managing test data