Data masking of Prod data in a non-prod Oracle Database
I have a need to load prod data in an Oracle 12c Database that contains PHI and PII data (names, addresses, etc.) into a non-prod (Stage) environment Oracle 12c Database to support performance testing. The applicable PHI and PII data will need to be masked after it is loaded into the Stage environment. Some of the data needing masking (scrambling) is in a Blob. What recommendations are there for masking software to use and the overall approach to solving this issue?