DataPump Export (EXPDP) Fails With Error ORA-39127
(Doc ID 1435388.1)
Last updated on JANUARY 28, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.7 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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
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
------- ---------- ------ -----------------------------------
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
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 |
| References |