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

(Doc ID 2136124.1)

Last updated on JUNE 02, 2017

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


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