expdp報錯ORA-39181

想死又怕死發表於2020-11-28

問題描述:
expdp過程中,報錯:
ORA-39181: Only partial table data may be exported due to fine grain access control on “ray”.“BALOU_DETAIL_CHARGE”
參考MOS文件:
ORA-39181:Only Partial Table Data Exported Due To Fine Grain Access Control (Doc ID 422480.1)

解決方法:

grant EXEMPT ACCESS POLICY to ray;

禁用VPD策略
DBMS_RLS.ENABLE_POLICY ('ray','BALOU_DETAIL_CHARGE','SURE','FALSE');

相關文章