My Oracle Support Banner

DataPump Import (IMPDP) Fails To Load Comments Due to ORA-06502 And LPX-00217 (Doc ID 2251257.1)

Last updated on MAY 18, 2021

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle 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.


While running a full DataPump job, the errors below are hit when processing the comments:

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



There are no changes in source database or target database.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.