[oracle@~ datadump]$ expdp system/oracle directory=dir_dp dumpfile=ts.dmp logfile=ts.log tablespaces=users

Export: Release 11.2.0.4.0 - Production on Fri Jul 29 19:52:00 2016

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Starting "SYSTEM"."SYS_EXPORT_TABLESPACE_01": system/******** directory=dir_dp dumpfile=ts.dmp logfile=ts.log tablespaces=users

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 1.062 MB

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

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

. . exported "OE"."PURCHASEORDER" 243.9 KB 132 rows

. . exported "OE"."CATEGORIES_TAB" 14.14 KB 22 rows

. . exported "OE"."PRODUCT_REF_LIST_NESTEDTAB" 12.5 KB 288 rows

. . exported "OE"."SUBCATEGORY_REF_LIST_NESTEDTAB" 6.578 KB 21 rows

. . exported "SCOTT"."DEPT" 5.929 KB 4 rows

. . exported "SCOTT"."EMP" 8.562 KB 14 rows

. . exported "SCOTT"."SALGRADE" 5.859 KB 5 rows

. . exported "SCOTT"."SL_BASE" 5.906 KB 3 rows

. . exported "SCOTT"."T" 5.007 KB 1 rows

. . exported "SCOTT"."BONUS" 0 KB 0 rows

Master table "SYSTEM"."SYS_EXPORT_TABLESPACE_01" successfully loaded/unloaded

******************************************************************************

Dump file set for SYSTEM.SYS_EXPORT_TABLESPACE_01 is:

/home/oracle/datadump/ts.dmp

Job "SYSTEM"."SYS_EXPORT_TABLESPACE_01" completed with 1 error(s) at Fri Jul 29 19:52:25 2016 elapsed 0 00:00:24

解决办法：

SYS@~>grant EXEMPT ACCESS POLICY to system;

Grant succeeded.

ITPub博客

数据泵导出表空间时报出ORA-39181错误的解决办法