ORA-39166 or ORA-31655 on Datapump Export With Content=DATA_ONLY (Doc ID 2089246.1)

Last updated on MAY 25, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

Exporting tables using CONTENT=DATA_ONLY fails with errors like:


Example:

expdp system/***** directory=test tables=test.dept_ext content=data_only dumpfile=testx.dmp

Export: Release 11.2.0.4.0 - Production on Thu Feb 26 18:37:19 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

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_TABLE_01": system/******** directory=test tables=test.dept_ext content=data_only dumpfile=testx.dmp
Estimate in progress using BLOCKS method...
Total estimation using BLOCKS method: 0 KB
ORA-39166: Object TEST.DEPT_EXT was not found.
ORA-31655: no data or metadata objects selected for job
Job "SYSTEM"."SYS_EXPORT_TABLE_01" completed with 2 error(s) at Thu Feb 26 18:37:21 2015 elapsed 0 00:00:01

 
Connecting as SYSTEM user, the one performing the export, the table can be found without any issues:

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms