ORA-39083 ORA-01119 ORA-27040 During Data Pump Import
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.3 [Release 10.1 to 10.2]
Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.2]
Information in this document applies to any platform.
This problem can occur on any platform.
impdp system/******** full=y dumpfile=DPIMPORT:CONPROD.dmp
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-01119: error in creating database file '/db/CONPROD/data/cmundo01.dbf'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Failing sql is:
CREATE UNDO TABLESPACE "CMUNDO" DATAFILE '/db/CONPROD/data/cmundo01.dbf' SIZE 629145600 AUTOEXTEND
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms