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 -> Re: Create a new Table Space on a Linux Server causing errors (ORA-01119 , ORA-27037)

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

From: Frank <fvanbortel_at_netscape.net>
Date: Sat, 26 Apr 2003 21:11:10 +0200
Message-ID: <3EAAD9CE.8050005@netscape.net>


Sybrand Bakker wrote:

> "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
> 
> 
> 
> Read the O/S error: No such file or directory.
> Now check whether the directory exists.
> Please try to avoid posting every individual error rightaway
> 
> 

And please make that a locally managed ts. pctincrease 1? Tsk, tsk tsk

-- 
Regards, Frank van Bortel
Received on Sat Apr 26 2003 - 14:11:10 CDT

Original text of this message

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