Pages

Friday, July 26, 2013

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

While running datapump on some of the schemas I faced following error.

ORA-39181: Only partial table data may be exported due to fine grain access control on <owner>.<table>.
A direct hit Oracle Note "422480.1" says it is caused if an unprivileged user who tries to export a table with a fine grain access control policy applied.
I have been using SYSTEM for export, and that doesn't look under privilege user.

But for such case, whatever the user we are using to run export/import.

SQL> Grant Exempt Access Policy to <User>;


In my case it was 

SQL> Grant Exempt Access Policy to System; 

Do the export/import task and again do not forget to 

SQL> Revoke Exempt Access Policy from 
<User>; 

It's usually not advisable to keep it granted, until unless you have a specific admin user for import - export.