Data Pump EXPDP Error: ORA-39181: Only partial table data may be exported due to fine grain access control on

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World

Error Description:
Data pump expdp log shows following error for some tables during the export.
ORA-39181: Only partial table data may be exported due to fine grain access control on "SCOTT"."CONTROL_ITEMS"


Solution Description:
This error occurs when a unprivileged user tries to export the tables which are enabled with Fine Grain Access Control policies. You can verify these kind of tables using the below query.

select * from dba_policies where OBJECT_OWNER='SCOTT' AND OBEJCT_NAME=’CONTROL_ITEMS’


It is recommended that the database administrator has to handle the export dump. Or to access such tables the user must have the EXEMPT ACCESS POLICY privilege. Once you give above privilege to the user then the export will work as normal. If it is one time export from the particular user as administrator you can disable the VPD policy and re-enable the policy again once the export completes.

grant EXEMPT ACCESS POLICY to scott;

_____________________________________________________________________________________________________________________

A visitor from Moscow viewed 'How to Recover the Oracle 10g 11g Database from RM' 33 mins ago
A visitor from Alabama viewed 'Golden Gate ggsci start manager: ERROR: Parameter ' 34 mins ago
A visitor from Kerala viewed 'ORA-00059: maximum number of DB_FILES exceeded - F' 1 hr 37 mins ago
A visitor from Phnom penh viewed 'FIX RMAN-11001 ORA-01547 "warning: RECOVER succeed' 2 hrs 40 mins ago
A visitor from Nagpur viewed 'RMAN-08591: WARNING: invalid archived log deletion' 4 hrs 14 mins ago

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-25 All Rights Reserved | Site Map | Contact | Disclaimer