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

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.
  Received on Fri Oct 20 2000 - 08:31:16 CDT