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
'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.
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
LikeLike
Just Remove the @ symbol in password
LikeLike