Oracle Error Message
ORA-12472: policy string is being used
Reason for the Error
The policy which was being dropped due to event propagation from OID was applied to some table or schema.
Solution
Drop a policy in OID only if it is not used in any of the databases using the policy.