David
Just check whether the temp tablespace is on LMT or DMT? If it is on
DMT, then you have to specify the storage clause.

ALTER TABLESPACE tbs_03
ADD TEMPFILE 'tbs_f04.dbf'
SIZE 50K
AUTOEXTEND ON
NEXT 10K
MAXSIZE 100K;

Hope this helps.

Regards,
Rahul Dutta


-----Original Message-----
From: Poole David
[mailto:oracledba-ezmlmshield-x27905957.[Email address protected]
Sent: Thursday, June 30, 2005 6:40 PM
To: LazyDBA Discussion
Subject: Temp Tablespace

Guys

How do you allocate a new tempfile to the temporary table space? Each
time I
try I get the following:

> alter tablespace temporary
add tempfile '/pin/oradata/PIN2/temp/temp02.dbf' size 2M;

alter tablespace temporary
*
ERROR at line 1:
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE

Cheers
David



Systems Operations
Thus Ltd Demon.net
i : 740 4153
e : 0141 273 4153
m : 07880 502 093



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page