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

From: Kessels E. <E.Kessels_at_centraal.boekhuis.nl>
Date: Fri, 20 Oct 2000 11:02:25 +0200
Message-ID: <78CC0C89B41DD311B8900000F6CB6A8E06B3EA@SRVEXCH1>

Make sure the Oracle_home is known. I think you should use $ORACLE_HOME (in uppercase). From the prompt you can use 'echo $ORACLE_HOME' to check

Kind Regard
Edwin Kessels

-----Oorspronkelijk bericht-----
Van: Sunny cheung [mailto:sunny_at_digitalmizzion.com] Gepost om: vrijdag, 20 oktober, 2000 9:43 Gepost naar: server
Discussie: create new tablespace (redhat linux 6.2 + oracle 8i) Onderwerp: create new tablespace (redhat linux 6.2 + oracle 8i)

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. Received on Fri Oct 20 2000 - 04:02:25 CDT