Multiple Schema Compare generates DROP POLICY statements for Data Redaction Policies.
The same Redaction policies exist on an 11g RAC database and a 12c RAC database. Multiple schema compare generates the following:
BEGIN SYS.DBMS_REDACT.DROP_POLICY ( object_schema => 'sname', object_name => 'uname', policy_name => 'uname_rp'); END;
Why are these drops being generated if the policies exist in both databases?
WORKAROUND
Un-check 'Redaction Policies' from the 'Options | Object Types to Compare' tab of (Multiple) Schema Compare
STATUS
Fixed in version 12.11. The latest release can be downloaded here.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center