Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Create a new Table Space on a Linux Server causing errors (ORA-01119 , ORA-27037)
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
![]() |
![]() |