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

From dbawiki
Jump to: navigation, search
(Created page with "===Problem=== Getting error "'''ORA-28112: failed to execute policy function'''" when exporting or importing using DataPump During expdp is accompanied by "'''ORA-31693: Table da...")
 
(Blanked the page)
 
(4 intermediate revisions by one other user not shown)
Line 1: Line 1:
−
===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 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
 

Latest revision as of 13:58, 6 March 2015

Retrieved from "https://mailnest.com/dbawiki/index.php?title=ORA-28112:_failed_to_execute_policy_function&oldid=1816"