Re: Help on creating tablespace

Hi Thomas,

I am not sure but I think that you have to add drive and pathname to the filename.

e.g.

create tablespace UsrDat datafile 'C:\Oradata\UsrDat.dat';

Bye
  Jos

Thomas Løvlie <thomasl_at_c2i.net> schreef in berichtnieuws Eh3N4.3748$OQ3.552770_at_juliett.dax.net...
> I am using Personal Oracle and I have a problem with creating a tablespace
> to work with.
>
> I write 'create tablespace UsrDat datafile 'UsrDat.dat';'
>
> But I keep getting the error:
>
> create tablespace UsrDat datafile 'UsrDat.dat'
> *
> ERROR at line 1:
> ORA-01119: error in creating database file 'UsrDat.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.
>
> Can anyone tell me what I am doing wrong?
>
> Thanks in advance
>
> -Thomas Løvlie
> thomasl_at_c2i.net
> Delphi Developer for Digitalteknikk AS
>
>
Received on Tue Apr 25 2000 - 00:00:00 CDT