DataPump Import (IMPDP) Fails With Errors ORA-39125 ORA-06502 LPX-240
(Doc ID 875533.1)
Last updated on JULY 29, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.4 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 Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Performing a DataPump import the following errors occurred:
object type SCHEMA_EXPORT/VIEW/VIEW Processing object type
SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER Processing object type
SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while calling
DBMS_METADATA.CONVERT [TABLE_STATISTICS]
ORA-06502: PL/SQL: numeric or value error
LPX-00240: element-start tag is not well formed
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6313
----- PL/SQL Call Stack -----
object line object
handle number name
3c1ee9da8 15032 package body SYS.KUPW$WORKER
3c1ee9da8 6372 package body SYS.KUPW$WORKER
3c1ee9da8 12391 package body SYS.KUPW$WORKER
3c1ee9da8 3346 package body SYS.KUPW$WORKER
3c1ee9da8 6972 package body SYS.KUPW$WORKER
3c1ee9da8 1314 package body SYS.KUPW$WORKER
3c4d0b9a0 2 anonymous block
Job "SYSTEM"."SYS_IMPORT_FULL_02" stopped due to fatal error at 00:19:26
SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER Processing object type
SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while calling
DBMS_METADATA.CONVERT [TABLE_STATISTICS]
ORA-06502: PL/SQL: numeric or value error
LPX-00240: element-start tag is not well formed
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6313
----- PL/SQL Call Stack -----
object line object
handle number name
3c1ee9da8 15032 package body SYS.KUPW$WORKER
3c1ee9da8 6372 package body SYS.KUPW$WORKER
3c1ee9da8 12391 package body SYS.KUPW$WORKER
3c1ee9da8 3346 package body SYS.KUPW$WORKER
3c1ee9da8 6972 package body SYS.KUPW$WORKER
3c1ee9da8 1314 package body SYS.KUPW$WORKER
3c4d0b9a0 2 anonymous block
Job "SYSTEM"."SYS_IMPORT_FULL_02" stopped due to fatal error at 00:19:26
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 |