用数据泵导数据库

expdp system/oracle_4U directory=exp_dir dumpfile=emprep.dmp full=y logfile=emprep.log 报错ORA-39181，如下所示

ORA-39181 Only partialtable data may be exported ..._oracle

经查询资料，此原因为迁移时如果没有赋给用户exempt access policy权限就会出现此异常

ORA-39181: Only partialtable data may be exported due to fine grain access control on "OE"."PURCHASEORDER"

现赋予权限

SQL> grant exempt access policy to system;

Grant succeeded.

再次执行expdp操作，正常将全库导出，由于数据库不大，导出时花的时间不长.

ORA-39181 Only partialtable data may be exported ..._数据泵_02