ORA-39181: Only partial table data may be exported due to fine grain access control

ORA-39181: Only partial table data may be exported due to fine grain access control

ORA-39181: Only partial table data may be exported due to fine grain access control on “”.”WORKFLOW_ACTION_PARAM”
. . exported “******”.”WORKFLOW_ACTION_PARAM” 0 KB 0 rows
ORA-39181: Only partial table data may be exported due to fine grain access control on “******”.”WORKING_LIST”

I tried expdp as system user.It seems system user is not able to export full data of these tables due to vpd policies enabled (FGAC).

We can check that  in dba_policies

select object_name from dba_policies where object_owner=’OWNER_NAME’;

Solution :

In order to avoid this error,we have to grant EXEMPT ACCESS POLICY to the exporting user(in our case user:system) and restart export.Database users granted the EXEMPT ACCESS POLICY privilege, either directly or through a database role, are exempt from VPD enforcements.

grant EXEMPT ACCESS POLICY to SYSTEM;

EXEMPT ACCESS POLICY is a very powerful privilege and should be carefully managed.so once we are done with export,just revoke it.

revoke EXEMPT ACCESS POLICY  from system;