Oracle by Anand

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

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

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