This is a common requirement for DBA to export data from production for various purposes. In a restricted & compliant environment it’s a must to mask / scrub particular data while exporting from production.
Here’s a simple demonstration. I’ve got the hint from metalink.
1. Create a package to mask data
Note: The package needs to be created under the schema which would be used to connect to datapump utility. I’ve used SYSTEM user for this case.
2. Datapump export with REMAP_DATA parameter:
We’d be using the created package to scrub data for particular table columns. My package would basically replace all mentioned column data into ‘xxxxx’
For this example, I’ve chosen to scrub HR.FIRST_NAME & SALES. The export dump would export the FNADVI schema as well as the the table mentioned with scrubbed column.
3. Import the schema
Now you the import can be done anywhere with scrubbed data.