Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 25 2015

Added on Jul 26 2015

#database, #general-database-discussions, #oem, #oracle, #sql

7 comments

4,262 views