expdp导出报ORA-39181的处理方法

在expdp导出过程中，报ORA-39181: Only partial table data may be exported due to fine grain access control错误，
官网关于该错误的描述如下：
// *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.
大概意思就是权限的问题，一个没有权限的用户在导出一个细粒度访问策略控制的表。
解决办法：将 EXEMPT ACCESS POLICY 权限授予system。
grant EXEMPT ACCESS POLICY to system;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31403259/viewspace-2141648/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31403259/viewspace-2141648/