ORA-01119 and ORA-27040 Database file creation error

Hello,

i am trying to create a database in Oracle 9.2.7 for Windows.

I am using Windows XP.

The used directory exists and i have write permission...

My Code for SQL:
create tablespace xxx_install
datafile ' c:\oracle\oradata\xxx_install01.dbf'
size 160M
autoextend on next 10M maxsize 1999M;

This is the error output:
ERROR at line 1:
ORA-01119: error in creating database file '
c:\oracle\oradata\swtest\liprod_d01.dbf'
ORA-27040: skgfrcre: create error, unable to create file

Please help me to fix this.

Regards Stefan
woiglAsked:
Who is Participating?
 
MikeOM_DBACommented:

Also you may want to use the Enterprise Manager console (GUI) to administrate your DB.
0
 
MikeOM_DBACommented:
Are you sure you have permissions?

Oracle 9.2 or Earlier Error Message
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Error:      ORA-27040
Text:      skgfrcre: create error, unable to create file
---------------------------------------------------------------------------
Cause:      create system call returned an error, unable to create file
Action:      verify filename, and permissions
0
 
woiglAuthor Commented:
Yes, the Admin didnt had an assignment to the DBA group... it works now!!

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.