My Oracle Support Banner

LPX-00216: "invalid character 0 (0x0)" When Importing Triggers With Data Pump (Doc ID 1628079.1)

Last updated on JULY 29, 2019

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Symptoms

When executing a Data Pump import, errors like below are raised when importing triggers:

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TRIGGER:"<trigger owner>"."<trigger name>"]
ORA-06502: PL/SQL: numeric or value error
LPX-00216: invalid character 0 (0x0)

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9715

----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x617037b8     21979  package body SYS.KUPW$WORKER
0x617037b8      9742  package body SYS.KUPW$WORKER
0x617037b8     17950  package body SYS.KUPW$WORKER
0x617037b8      4058  package body SYS.KUPW$WORKER
0x617037b8      4862  package body SYS.KUPW$WORKER
0x617037b8     10492  package body SYS.KUPW$WORKER
0x617037b8      1824  package body SYS.KUPW$WORKER
0x71cafdd0         2  anonymous block

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


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