My Oracle Support Banner

DataPump Import (IMPDP) Job Fails To Start Due To ORA-02354 And ORA-39773 (Doc ID 2136124.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


The following errors are encountered when starting an impdp job to load the data from the dump files generated by an expdp job executed with parallel>1:

ORA-39002: invalid operation
ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_02" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-39773: parse of metadata stream failed

In the target environment, one of the dump files is significantly smaller than the others:

[oracle@guaruja export]$ ls -ltr MONI*CLARO*.dmp
-rwxrwxrwx 1 ccoimbra domain users 14061568 Apr 27 11:17 MONITOR_CLARO_01.dmp
-rwxrwxrwx 1 ccoimbra domain users 10730053632 Apr 27 11:20 MONITOR_CLARO_02.dmp
-rwxrwxrwx 1 ccoimbra domain users 9892257792 Apr 27 11:23 MONITOR_CLARO_03.dmp
-rwxrwxrwx 1 ccoimbra domain users 10792484864 Apr 27 11:27 MONITOR_CLARO_04.dmp
-rwxrwxrwx 1 ccoimbra domain users 10459795456 Apr 27 11:30 MONITOR_CLARO_05.dmp
-rwxrwxrwx 1 ccoimbra domain users 11139579904 Apr 27 11:31 MONITOR_CLARO_06.dmp


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.