Getting ORA-39181: Only partial table data may be exported due to fine grain access control
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.
To avoid this:
Grant the privilege EXEMPT ACCESS POLICY to the exporting user
-or-
Disable the VPD policy.
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:
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
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"
. . 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
******************************************************************************
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