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 220.127.116.11 and later
Information in this document applies to any platform.
Datapump import fails with following errors:
Connected to: Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 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:
threads(per process) unlimited
processes(per user) unlimited
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|