You can create a Data Redaction policy that does not perform redaction. This enables you to include redaction policies in your applications during testing, and then apply those polices to your data as you move the application to production.

This is useful for cases in which you have a redacted base table, yet you want a specific application user to have a view that always shows the actual data. By default, a view created on a redacted table is redacted with the same policy used for the base table. However, you can define a separate redaction policy for the view. You can create a new view of the redacted table and then define a Data Redaction policy for this view. When the application queries the view, the policy defined on the view is applied. The policy still exists on the base table, but no redaction is performed when the application queries using the view as long as the DBMS_REDACT.NONE function_type setting was used to create a policy on the view.