How to unmask data in OEM 10gR5
Management has asked (I don't know WHY), if there is a way to unmask data that has been masked !
So I reviewed the following:
Oracle® Enterprise Manager Concepts
10g Release 5 (10.2.0.5)
Part Number B31949-10
Chapter 5 Database Management
Masking Sensitive Data for Non-production Use
Of course I could backup the affected tables before masking, gut there is a table called MGMT_DM_TT that contains "a mapping between the original sensitive column value"
Can anyone confirm that this is the table that is needed to unmask data and if so, then "unmasking" would require a custom script?