ORA-39181: Only partial table data may be exported due to fine grain access control on "TEST"."CARDS"

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


Cause

This is expected behavior

ORA-39181 is caused by an unprivileged user who tries to export a table with a fine grain access control policiy applied.

Solution

To avoid this:

 Grant the privilege EXEMPT ACCESS POLICY to the exporting user

 -or-

 Disable the VPD policy.

Extract of Logs

expdp admin@ORCL1 parfile=ORCL_TEST_EXP.par

Export: Release 12.1.0.2.0 - Production on Fri Mar 9 10:13:33 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
Password:
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
Starting "ADMIN"."SYS_EXPORT_SCHEMA_01":  admin/********@ORCL1 parfile=ORCL_TEST_EXP.par
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 375.4 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/RLS_POLICY/RLS_POLICY
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

.....................................................................................
.....................................................................................
.....................................................................................
ORA-39181: Only partial table data may be exported due to fine grain access control on "TEST"."TE_CLAIM"
. . exported "TEST"."TE_CLXIM"                        37.48 KB      23 rows
. . exported "TEST"."TE_CLXIMBUSINESSDXTX"            6.882 KB      24 rows
. . exported "TEST"."TE_CLXIMOT"                      7.523 KB      23 rows
. . exported "TEST"."TE_CLXIMSEXRCHIDX"               14.92 KB      23 rows
. . exported "TEST"."TE_CLEXRINGXDDDXTX"              15.82 KB     324 rows
. . exported "TEST"."TE_CLEXRINGITEM"                 7.406 KB      48 rows
. . exported "TEST"."TE_CLEXRINGRECORD"               7.171 KB      48 rows
ORX-39181: Only partial table data may be exported due to fine grain access control on "TEST"."TE_DOCUMENT"
.....................................................................................
.....................................................................................
.....................................................................................

Master table "ADMIN"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for ADMIN.SYS_EXPORT_SCHEMA_01 is:
  /u01/exp/ORCL/ORCL_TEST.dmp
Job "ADMIN"."SYS_EXPORT_SCHEMA_01" completed with 21 error(s) at Fri Mar 9 10:14:55 2018 elapsed 0 00:01:12


3 comments:

  1. Issue Resolved after use this. Thanks a lot.

    Regards
    Gaurav Sharma
    https://gauravoracledba.blogspot.com

    ReplyDelete
  2. Your post will be rather good, Thanks so much for your post, Keep Posting.
    SAFEALL ADP & VDP In Delhi

    ReplyDelete
  3. Excellent blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
    Workday Online Training
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training
    Oracle Fusion Financials Online Training

    ReplyDelete