DataPump Import (IMPDP) Fails To Load Comments Due to ORA-06502 And LPX-00217
(Doc ID 2251257.1)
Last updated on SEPTEMBER 19, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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.
Symptoms
While running a full DataPump job, the errors below are hit when processing the comments:
...
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [COMMENT]
ORA-06502: PL/SQL: numeric or value error
LPX-00217: invalid character 0 (U+0000)
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001
----- PL/SQL Call Stack -----
object line object
handle number name
0x134309688 20462 package body SYS.KUPW$WORKER
0x134309688 9028 package body SYS.KUPW$WORKER
0x134309688 16665 package body SYS.KUPW$WORKER
0x134309688 3956 package body SYS.KUPW$WORKER
0x134309688 9725 package body SYS.KUPW$WORKER
0x134309688 1775 package body SYS.KUPW$WORKER
0x11c8eae00 2 anonymous block
ORA-39097: Data Pump job encountered unexpected error -1427
ORA-39065: unexpected master process exception in DISPATCH
ORA-01427: single-row subquery returns more than one row
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [COMMENT]
ORA-06502: PL/SQL: numeric or value error
LPX-00217: invalid character 0 (U+0000)
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001
----- PL/SQL Call Stack -----
object line object
handle number name
0x134309688 20462 package body SYS.KUPW$WORKER
0x134309688 9028 package body SYS.KUPW$WORKER
0x134309688 16665 package body SYS.KUPW$WORKER
0x134309688 3956 package body SYS.KUPW$WORKER
0x134309688 9725 package body SYS.KUPW$WORKER
0x134309688 1775 package body SYS.KUPW$WORKER
0x11c8eae00 2 anonymous block
ORA-39097: Data Pump job encountered unexpected error -1427
ORA-39065: unexpected master process exception in DISPATCH
ORA-01427: single-row subquery returns more than one row
Changes
There are no changes in source database or target database.
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 |