Re: Help on creating tablespace

not only you need to specify the absolute path names but you need to specify the size of the datafile
eg: 100k for 100kb
100m for 100mb etc.
sreedhar

In article <Eh3N4.3748$OQ3.552770_at_juliett.dax.net>,   "Thomas Løvlie" <thomasl_at_c2i.net> wrote:
> 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
>
>

--
Sreedhar


Sent via Deja.com http://www.deja.com/
Before you buy.