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?
If you are looking to just randomly change the Data, you can create an Activity and use ObjBrowse and loop through all the records and change the value of required properties.
Obj save post this would commit changes in the BLOB.