ORA-39006: Internal Error running expdp or DBMS_DATAPUMP export (Doc ID 1594804.1)

Last updated on AUGUST 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 07-May-2015***

Symptoms

When dbms_datapump.add_file is called by command line export or datapump API, it fails with:

ORA-39006: internal error
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3507
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3756
ORA-06512: at line 11


In this example, the errors occured after removing the Streams configuration and moving the database to no archivelog mode.

Running catproc.sql does not solve the issue.

This error may be raised for various exports in command line and with the Datapump API.

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