DataPump Export (EXPDP) Fails With Error ORA-39127 (Doc ID 1435388.1)

Last updated on APRIL 22, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Jan-2016***

Symptoms

During dataPump export (expdp) you received the following errors:

ORA-39127: unexpected error from call to BEGIN :1 := SYS.DBMS_JAVA.START_EXPORT(:2, :3, :4, :5, :6, :7, :8, :9 ,:10); END;
ORA-06550: line 1, column 13:
PLS-00201: identifier 'SYS.DBMS_JAVA' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_METADATA", line 6055


The registry output shows:

COMP_ID VERSION    STATUS COMP_NAME
------- ---------- ------ -----------------------------------
CONTEXT 11.1.0.7.0 VALID  Oracle Text
CATALOG 11.1.0.7.0 VALID  Oracle Database Catalog Views
CATPROC 11.1.0.7.0 VALID  Oracle Database Packages and Types


Also after removing DDBMS_JAVA package from the export (i.e. from sys.exppkgact$) and dropping the package DBMS_JAVA and the synonym, still the same errors are received.

 

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