Difference between revisions of "ORA-28112: failed to execute policy function"

Revision as of 12:48, 9 December 2011

Problem

Getting error "ORA-28112: failed to execute policy function" when exporting or importing using DataPump During expdp is accompanied by "ORA-31693: Table data object "SYSMAN"."MGMT_IP_REPORT_DEF" failed to load/unload and is being skipped due to error:"

Reason

This happens due to audit policies being defined on the table but the policy function is defined in another schema.

Solution

Either drop the policy after importing the table with:

begin
  for rec in (select * from dba_audit_policies where object_schema = 'SYSMAN') loop
  dbms_fga.drop_policy(object_schema => rec.object_schema,
                         object_name => rec.object_name,
                         policy_name => rec.policy_name);  
  end loop;
end;
/

or exclude the policies during export by adding this to the .par file:

exclude=FGA_POLICY

or even better, give the necessary grants to the exporting user...

grant exempt access policy to impexpusr;

The dba role and sysdba have this automatically.