$ oerr ora 39181

39181, 0000, "Only partial table data may be exported due to fine grain access control on %s"

// *Cause:  An unprivileged user has tried to export a table that has fine

//          grain access control. The table owner is subjected to access

//          control and may not be able to export all rows in the table.

//          Only the rows that can be seen by that user will be exported. In

//          order to preserve integrity of the table, the user importing the

//          table should have enough privilege to recreate the table with the

//          security policies at import time.

// *Action: It is strongly recommended that the database administrator handle

//          exporting of this table.

VPD and Oracle Label Security are not enforced during DIRECT path export and similarly, database users granted the EXEMPT ACCESS POLICY privilege, either directly or through a database role, are exempt from VPD enforcements. However, the following policy enforcement options remain in effect even when EXEMPT ACCESS POLICY is granted:

* INSERT_CONTROL, UPDATE_CONTROL, DELETE_CONTROL, WRITE_CONTROL, LABEL_UPDATE, and LABEL_DEFAULT

EXEMPT ACCESS POLICY  is a strong privilege and must be granted with care. For example , grant it to the role exp_full_database role as this role is granted to admin users only.

EXEMPT ACCESS POLICY是一个非常大的权限，授权时候必须小心。例如只授予拥有exp_full_database角色的管理账户EXEMPT ACCESS POLICY的权限。

To avoid this:

 Grant the privilege EXEMPT ACCESS POLICY to the exporting user

 -or-

 Disable the VPD policy.