Datapump Import Fails with Errors ORA-39002 ORA-31694 ORA-31640 ORA-19505 ORA-27092

(Doc ID 1569887.1)

Last updated on DECEMBER 18, 2014

Applies to:

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


Datapump import fails with following errors:

Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
ORA-39002: invalid operation
ORA-31694: master table "SYSTEM"."SYS_IMPORT_FULL_01" failed to load/unload
ORA-31640: unable to open dump file "/EXP_2013-07-15.dmp" for read
ORA-19505: failed to identify file "/EXP_FULL_2013-07-15.dmp"
ORA-27092: size of file exceeds file size limit of the process
Additional information: 262143
Additional information: 4508174

Ulimits for Datapump user are set to unlimited:
ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        unlimited
memory(kbytes)       unlimited
coredump(blocks)     unlimited
nofiles(descriptors) unlimited
threads(per process) unlimited
processes(per user)  unlimited


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