I have been running an export on our Development Grid Control (Cloud control 12c R3) , which is running 220.127.116.11 version of the database running on Linux(Red Hat). After the upgrade, the VPD has been placed on many SYSMAN tables.
ORA-39181:Only Partial Table Data Exported Due To Fine Grain Access Control
I use the “SYSTEM” user and it appears that the system user is not able to export full data of these tables due to vpd policies enabled.
To Check the dba_policies
select object_name from dba_policies where object_owner=’SYSMAN’;
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;
Once completed, the error was resolved .