Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Create a new Table Space on a Linux Server causing errors (ORA-01119 , ORA-27037)
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<valhl9d1rspmc0_at_corp.supernews.com>...
> "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
The directory does exist
/u01/app/oracle/oradata/SSDB/ Received on Sat Apr 26 2003 - 18:46:03 CDT