Re: Oracle 8.1.7, Windows XP and file creation errors

You might want to look at the 'create tablespace' command in the docs .

You need to specify an initial size for one thing.

"JamesM" <jamesm_at_hpl.com> wrote in message news: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'
> *
> 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.
>
> A fully qualified path such as c:\dbs\mytable.dat produces the same
> error.
> If the table size is specified the same error.
> i.e.
> create tablespace mytable
> datafile 'c:\dbs\mytable.dat'
> 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 Sun Jun 09 2002 - 04:17:09 CEST