Oracle 8.1.7, Windows XP and file creation errors
Date: 7 Jun 2002 13:08:16 -0700
Message-ID: <3745b60.0206071208.3dbbc6b2_at_posting.google.com>
I am trying to run Oracle 8.1.7 under Windows XP Professional. When I
issue the command:
create tablespace mytable datafile 'mytable.dat';
I recieve the following error:
create tablespace mytable datafile 'mytable.dat'
*
A fully qualified path such as c:\dbs\mytable.dat produces the same
error.
datafile 'c:\dbs\mytable.dat'
ERROR at line 1:
ORA-01119: error in creating database file 'mytable.dat'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
If the table size is specified the same error.
i.e.
create tablespace mytable
default storage ( initial 14k
next 14k
minextents 1
maxextents unlimited
pctincrease 0
) ;
Even though this computer is on a network where user files are stored
on a server, a server path still produces the same error
(\\server2\Users\jamesm\DataFactory\mytable.dat). There is 5 gigabytes
on the computer and 24 gigabytes on the network server, so there is
plenty of space for file creation.
If anyone has any ideas, it would be appreciated!!
James Received on Fri Jun 07 2002 - 22:08:16 CEST