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
'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 reasons or solution for the error ORA-01119:
1. Please check the physical location is available on the disk. I
2. Is their any miss-spelling in providing the PATH which is not available and 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.

Advertisements

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 )

Google+ photo

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

Twitter picture

You are commenting using your Twitter 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.