Error Description:
Data pump expdp log shows following error for some tables during the export.
ORA-39181: Only partial table data may be exported due to fine grain access control on "SCOTT"."CONTROL_ITEMS"
Solution Description:
This error occurs when a unprivileged user tries to export the tables which are enabled with Fine Grain Access Control policies. You can verify these kind of tables using the below query.
select * from dba_policies where OBJECT_OWNER='SCOTT' AND OBEJCT_NAME=’CONTROL_ITEMS’
