DataPump Export (EXPDP) Fails Due To ORA-39126 And ORA-6502 When Unloading Java Objects
(Doc ID 2061532.1)
Last updated on APRIL 04, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
After upgrading from 11gR2 to 12cR1, DataPump Export (expdp) fails to unload java_source or java_class objects and returns the errors:
Export: Release 12.1.0.2.0 - Production on Mon Aug 10 15:12:09 2015
.....
Processing object type SCHEMA_EXPORT/JAVA_SOURCE/JAVA_SOURCE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GATHER_PARSE_ITEMS [JAVA_SOURCE:"<SCHEMA_NAME>"."<JAVA_SOURCE_NAME>"]
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259
----- PL/SQL Call Stack -----
object line object
handle number name
60f14d058 27116 package body SYS.KUPW$WORKER
60f14d058 11286 package body SYS.KUPW$WORKER
60f14d058 15779 package body SYS.KUPW$WORKER
60f14d058 9645 package body SYS.KUPW$WORKER
60f14d058 13381 package body SYS.KUPW$WORKER
60f14d058 3173 package body SYS.KUPW$WORKER
60f14d058 12035 package body SYS.KUPW$WORKER
60f14d058 2081 package body SYS.KUPW$WORKER
5e1bd6508 2 anonymous block
In procedure BUILD_SUBNAME_LIST with JAVA_SOURCE:<JAVA_SOURCE_NAME>
In function NEXT_PO_NUMBER
In function GATHER_PARSE_ITEMS
In function CHECK_FOR_REMAP_NETWORK
Nothing to remap
In procedure BUILD_OBJECT_STRINGS
In procedure BUILD_SUBNAME_LIST with JAVA_SOURCE:<JAVA_SOURCE_NAME>
In function NEXT_PO_NUMBER
In function GATHER_PARSE_ITEMS
In procedure DETERMINE_FATAL_ERROR with ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Job "SYS"."SYS_EXPORT_SCHEMA_06" stopped due to fatal error at Mon Aug 10 15:17:16 2015 elapsed 0 00:05:00
.....
Processing object type SCHEMA_EXPORT/JAVA_SOURCE/JAVA_SOURCE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GATHER_PARSE_ITEMS [JAVA_SOURCE:"<SCHEMA_NAME>"."<JAVA_SOURCE_NAME>"]
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259
----- PL/SQL Call Stack -----
object line object
handle number name
60f14d058 27116 package body SYS.KUPW$WORKER
60f14d058 11286 package body SYS.KUPW$WORKER
60f14d058 15779 package body SYS.KUPW$WORKER
60f14d058 9645 package body SYS.KUPW$WORKER
60f14d058 13381 package body SYS.KUPW$WORKER
60f14d058 3173 package body SYS.KUPW$WORKER
60f14d058 12035 package body SYS.KUPW$WORKER
60f14d058 2081 package body SYS.KUPW$WORKER
5e1bd6508 2 anonymous block
In procedure BUILD_SUBNAME_LIST with JAVA_SOURCE:<JAVA_SOURCE_NAME>
In function NEXT_PO_NUMBER
In function GATHER_PARSE_ITEMS
In function CHECK_FOR_REMAP_NETWORK
Nothing to remap
In procedure BUILD_OBJECT_STRINGS
In procedure BUILD_SUBNAME_LIST with JAVA_SOURCE:<JAVA_SOURCE_NAME>
In function NEXT_PO_NUMBER
In function GATHER_PARSE_ITEMS
In procedure DETERMINE_FATAL_ERROR with ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Job "SYS"."SYS_EXPORT_SCHEMA_06" stopped due to fatal error at Mon Aug 10 15:17:16 2015 elapsed 0 00:05:00
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |