在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;
官网关于该错误的描述如下：
// *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博客 ” ，链接：https://blog.itpub.net/31403259/viewspace-2141648/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
