My Oracle Support Banner

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

Last updated on JULY 01, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

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 occurred 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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.