OEM Masking and Subsetting package on Production Database
Hello Experts,
I am looking for solutions of Data masking on production environment, which would be some condition and retention based data masking.
We are planning to use the OEM13.2 Masking and Subsetting package to mask the data on production environment.
but during masking script execution it will follow the following process internally in database which can cause the application outage by renaming the table and removing/restoring the index/permissions etc.
Oracle note about this process - Quick Data Masking and Subsetting steps overview (Doc ID 2108098.1)
1> In-Database Masking Sequence
Steps performed for Normal table
- Drops all dependents like constraints, triggers, and indexes