Sanitize or Clean a database dump

[zzyplza]

I'm looking for a script that I can use to replace any database fields that my security people won't let outsiders see with innocuous values. I can't provide a dump of my Oracle database to a support organization without laboriously going through the dump and doing this obfuscation by hand.

Can anyone point me to an available script that I can use as a basis?

Thanks,
Chris.

[skhanal]

What kind of dump file are you editing? is it export dump file?.

There are many data masking product in the market. You can see one at www.datamasker.com which is quite good.

Or you can write your own stored procedures to change data before you dump it.