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


The below error appeared when trying to export the Schema using System User
. . exported "OC_CON"."DD_ALL_TABLE_COLUMNS" 299.0 KB 32693 rows
ORA-39181: Only partial table data may be exported due to fine grain access control on "OC_CRD"."CRD_CARD"
. . exported "OC_CRD"."CRD_CARD" 477.9 KB 5290 rows
. . exported "OC_EOC"."EOC_ACC_USED_LIMIT_BACKUP" 241.6 KB 41740 rows
Solution:
grant EXEMPT ACCESS POLICY to System;
Advertisements

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: