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)
Two things.
First, ORACLE_HOME is an environment variable, and is, er, invariably in uppercase.
At the operating system prompt, try typing 'export' on its own, and seeing what the list of environmental variables are. You should see ORACLE_SID, ORACLE_HOME... maybe ORACLE_BASE. You should also see what these things are set to.
I only mention that because environment variables are, er, variable: what it points to todays might not be what it points to tomorrow. You ought therefore to get into the habit of supplying the full path and filenames for these sorts of things. You can probably get away with it for now, but keep it in mind.
Second, your statement will fail because you are not specifying the size of your datafile.
Hence, try
create tablespace tstmp datafile '$ORACLE_HOME/oradata/tstmp.dbf' size 10Mb
(or whatever size is appropriate).
Regards
HJR
-- -------------------------------------------------------------------------- Opinions expressed are my own, and not those of Oracle Corporation Oracle DBA Resources: http://www.geocities.com/howardjr2000 -------------------------------------------------------------------------- "Sunny cheung" <sunny_at_digitalmizzion.com> wrote in message news:39eff829_at_newsgate.hknet.com...Received on Fri Oct 20 2000 - 09:40:20 CDT
> 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.
>
>