Re: create new tablespace (redhat linux 6.2 + oracle 8i)

From: <sybrandb_at_my-deja.com>
Date: Fri, 20 Oct 2000 09:48:30 GMT
Message-ID: <8sp4dd$olc$1@nnrp1.deja.com>

In article <39eff829_at_newsgate.hknet.com>, "Sunny cheung" <sunny_at_digitalmizzion.com> 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.
>
>

Within sqlplus the ? is used as abbreviation for ORACLE_HOME

regards,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Fri Oct 20 2000 - 04:48:30 CDT