"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:<pRMqa.23301$1s1.355921_at_newsfeeds.bigpond.com>...
> "LJA" <lou.ascoli_at_attws.com> wrote in message
> news:40a3ec87.0304260850.e18f814_at_posting.google.com...
> > I am trying to create a new Tablespace (8i) , on a Linux server using
> > Redhat , and I continue receive two errors. Any suggestion are
> > welcomed. Thank you.
> >
> >
> >
> > SQL> create tablespace RTESVR
> > 2 DATAFILE '/u01/app/oracle/oradata/SSDB/rtesvr01.dbf'
> > 3 autoextend on
> > 4 default storage(initial 10240 next 10240 minextents 1 maxextents
> > 2147483645 pctincrease 50)
> > 5 online
> > 6 permanent
> > 7 logging
> > 8 ;
> > create tablespace RTESVR
> > *
> > ERROR at line 1:
> > ORA-01119: error in creating database file
> > '/u01/app/oracle/oradata/SSDB/rtesvr01.dbf'
> > ORA-27037: unable to obtain file status
> > Linux Error: 2: No such file or directory
> > Additional information: 3
> >
> >
> > Alternate size settings
> >
> >
> >
> > SQL> create tablespace RTESVR
> > 2 DATAFILE '/u01/app/oracle/oradata/SSDB/rtesvr01.dbf'
> > 3 default storage(initial 1M NEXT 1M MINEXTENTS 1 MAXEXTENTS 100
> > PCTINCREASE 1)
> > 4 online
> > 5 permanent
> > 6 logging
> > 7 ;
> > create tablespace RTESVR
> > *
> > ERROR at line 1:
> > ORA-01119: error in creating database file
> > '/u01/app/oracle/oradata/SSDB/rtesvr01.dbf'
> > ORA-27037: unable to obtain file status
> > Linux Error: 2: No such file or directory
> > Additional information: 3
>
> Hi LJA,
>
> A couple of errors.
>
> Firstly, you have not specified a "SIZE" for your datafiles hence Oracle is
> making (the obviously incorrect) assumption that the files already exist :
>
> SQL> create tablespace RTESVR
> DATAFILE '/u01/app/oracle/oradata/SSDB/rtesvr01.dbf' SIZE 500M (or
> whatever ...)
>
> and you're away.
>
> Secondly, you're not creating a Locally Managed Tablespace which would make
> your poor choices for PCTINCREASE redundant.
>
> Good Luck
>
> Richard
Thank you .
Received on Sun Apr 27 2003 - 20:44:45 CDT
