Re: Create a new Table Space on a Linux Server causing errors (ORA-01119 , ORA-27037)

"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 Received on Sun Apr 27 2003 - 04:05:09 CDT