Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: create new tablespace (redhat linux 6.2 + oracle 8i)
Well it works on NT, but you have to use the correct syntax, and
casing:
SVRMGR> create tablespace blah datafile '%ORACLE_HOME%\blah.dbf' size 100k;
Statement processed.
SVRMGR> select name from v$datafile;
NAME
-- Frank Karen <karen.abgarian_at_fmr.com> schreef in berichtnieuws 39F04924.59C5191_at_fmr.com...Received on Tue Oct 24 2000 - 07:53:22 CDT
> The syntax is correct, but you cannot use shell variables. Substitute
> $oracle_home by its directory path.
>
> Sunny cheung wrote:
>
> > I just want to add new tablespace
> >
> > create tablespace tstmp datafile '$oracle_home/oradata/tstmp.dbf'
> >
> > the error returned is:
> > ora-01119: error in creating database file
'$oracle_home/oradata/tstmp.dbf'
> > ora-27040: skgfrcre:create error, unable to create file
> > Linux error :2: no such file or directory.
> >
> > Thx.
>