Reverting the Data Redaction for an individual Policy

To revert the data redaction for an individual policy:

1. Run the below query as a SYS user.
   select * from REDACTION_POLICIES t where t.object_name='##TABLE_NAME##';
2. Fetch the policy name from the table.
3. Update the below query and run in the atomic schema.

   
   begin
    dbms_redact.DROP_POLICY ( 
       object_schema => '##USER_NAME##',
       object_name => '##TABLE_NAME##',
       policy_name => '##POLICY_NAME##' );
   end;
   /