Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Depersonalize data

446099Apr 28 2008 — edited Apr 28 2008
Hello,

I would like to de-personalize a datamodel. For example in an employees table I would like to scramble or mix up the Firstname/Lastname and salary column.
Is there any tool to do this? I've been looking at DBMS_CRYPTO, but that's more for protecting data.

In my situation, I don't need te be able to 'go back' to the original data. We have a copy of production, and need to secure it before giving it to Development dept.

Any hints? It would be nice not to do a lot of manual labour and writing sql (translate) statements.

Thx.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 26 2008
Added on Apr 28 2008
13 comments
927 views