SQL> create tablespace gaotbs logging datafile '/u01/app/datafiles/gaodata1.dbf'
2  size 50M autoextend on next 50M maxsize 2048M
3  extent management local;
create tablespace gaotbs logging datafile '/u01/app/datafiles/gaodata1.dbf'
*
ERROR at line 1:
ORA-01119: error in creating database file '/u01/app/datafiles/gaodata1.dbf'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory

[root@o_target ~]# su - oracle
[oracle@o_target ~]$ cd /u01/app
[oracle@o_target app]$ ls
arch  arch1_6_842088414.dbf  oracle  oraInventory
[oracle@o_target app]$ mkdir datafiles
[oracle@o_target app]$ ls
arch  arch1_6_842088414.dbf  datafiles  oracle  oraInventory
[oracle@o_target app]$

SQL> create tablespace gaotbs logging datafile '/u01/app/datafiles/gaodata1.dbf'
2  size 50M autoextend on next 50M maxsize 2048M
3  extent management local;
Tablespace created.

Error Id: ORA-01119

Title: error in creating database file ’string’

Description:

error in creating database file ’string’

Action:

none

Cause:

Usually due to not having enough space on the device.

Error Id: ORA-27040

Title: file create error, unable to create file

Description:

file create error, unable to create file

Action:

verify filename, and permissions

Cause:

create system call returned an error, unable to create file

-- 来自：