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.

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



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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