While moving the data from production to staging or development test environment, what is the best way to mask some columns of some tables?
The two option I can think of are:
(A) Apply redaction policy as it is in built in oracle 12c
(B) Export data then apply script on columns the move the data to test environment.
Which of the two ways will be better?
If I go with (A) then I apply the redact.add_policy. But will this be automatically applied on the exported data?