Home > Oracle > ORA-39181: Only partial table data may be exported due to fine grain access control

ORA-39181: Only partial table data may be exported due to fine grain access control

when performing a full database export and export the rman catalog schema in 12.1.0.2 i can across the following error


ORA-39181: Only partial table data may be exported due to fine grain access control on "RMANCAT"."BCF"
. . exported "RMANCAT"."BCF" 0 KB 0 rows
ORA-39181: Only partial table data may be exported due to fine grain access control on "RMANCAT"."BP"
. . exported "RMANCAT"."BP" 0 KB 0 rows
ORA-39181: Only partial table data may be exported due to fine grain access control on "RMANCAT"."BS"
. . exported "RMANCAT"."BS" 0 KB 0 rows
ORA-39181: Only partial table data may be exported due to fine grain access control on "RMANCAT"."BSF"
. . exported "RMANCAT"."BSF" 0 KB 0 rows

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='RMANCAT' and object_name='BSF';

To resolve this issue

I granted the priviledge to the role DATAPUMP_EXP_FULL_DATABASE and then granted the role to the exporting user


grant EXEMPT ACCESS POLICY to DATAPUMP_EXP_FULL_DATABASE;
grant DATAPUMP_EXP_FULL_DATABASE to OPS$ORACLE

or

you could

Disable the VPD policy

Advertisements
Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: