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>;
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.
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.