ORA-39083 ORA-01119 ORA-27040 During Data Pump Import (Doc ID 460553.1)

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 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

When using Data pump Import to perform Import of the full database

impdp system/******** full=y dumpfile=DPIMPORT:CONPROD.dmp
logfile=DPIMPORT:CONPROD_imp_full_2.log job_name=CONPROD_Initial

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

Cause

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