Data Pump EXPDP Error: ORA-39181: Only partial table data may be exported due to fine grain access control on


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’

 

dba topics. Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google