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?