Tag Archives: unable to create file

ORA-01119: error in creating database file

ORA-01119: error in creating database file

While Creating a tablespace with data file in the Oracle Database received the following errors:

SQL> Create tablespace spatial_tbs datafile 'D:\oraclexe\app\oracle\XE\spatial_01.dbf' size 100m aut
oextend on;
Create tablespace spatail_tbs datafile 'D:\oraclexe\app\oracle\xe\spatial_01.dbf' size 100m autoexte
nd on
ERROR at line 1:
ORA-01119: error in creating database file
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

Following are the possible reasons and solution for the error ORA-01119:
1. Please check the physical location is available on the disk.
2. Is their any miss-spelling in providing the PATH which is not available.
3. Check the location must have write permission on the specified path in which you are creating the data files.
4. You are login with that user which is not a part of DBA group in Linux or ORA_DBA group in windows.