Skip to Main Content

Tablespace creation errors...

user10341978Jul 26 2015 — edited Jul 28 2015

SQL> create tablespace test datafile 'u01/app/oracle/oradata/database/test.dbf';

create tablespace test datafile 'u01/app/oracle/oradata/database/test.dbf'

*

ERROR at line 1:

ORA-01119: error in creating database file

'u01/app/oracle/oradata/databasel/test.dbf'

ORA-17610: file 'u01/app/oracle/oradata/database/test.dbf' does not exist and no

size specified

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

The path is correct as far as where all of the datafiles go. What am I missing?

Comments
Post Details
Added on Jul 26 2015
7 comments
3,588 views