DataPump Import (IMPDP) Fails With LPX-216 (Doc ID 1313550.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.5 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Nov-2013***

Symptoms

DataPump import fails with error:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31694: master table "SYSMAN"."SYS_SQL_FILE_FULL_01" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-39774: parse of metadata stream failed with the following error:
LPX-00216: invalid character 0 (0x0


Review of the Data Pump export logfile, it shows export is succesfully completed without errors.
DataPump import using the parameter SQLFILE to check the integrity of dump files, fails with the same error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms