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

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

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address