Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Create a new Table Space on a Linux Server causing errors (ORA-01119 , ORA-27037)

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

From: LJA <lou.ascoli_at_attws.com>
Date: 26 Apr 2003 09:50:18 -0700
Message-ID: <40a3ec87.0304260850.e18f814@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 Received on Sat Apr 26 2003 - 11:50:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US