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 autoextend on;
Create tablespace spatail_tbs datafile 'D:\oraclexe\app\oracle\xe\spatial_01.dbf' size 100m autoextend on
*
ERROR at line 1:
ORA-01119: error in creating database file
'D:\oraclexe\app\oracle\xe\spatial_01.dbf'
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.

Solution
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.

2 thoughts on “ORA-01119: error in creating database file

  1. Anonymous

    thank you so much for giving he best solution that is i have delete my physical data file in the path of our windows mission and it is executed now. thankyou

    Like

    Reply

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.