This would be my question also. Are you calling [have you named] your temporary tablespace 'temporary'? I would want to avoid using oracles reserved words or words that may have special meaning to oracle such as one we are talking about here. You are already mentioning the size for the file being added in your sql. So, that should be ok.
Gurmohan
www.freemath.info
---------------------------------------------------------------------------------------
-----Original Message-----
From: siva
[mailto:oracledba-ezmlmshield-x76638175.[Email address protected]
Sent: Thursday, June 30, 2005 9:24 AM
To: LazyDBA Discussion
Subject: Re: Temp Tablespace
Remove the temporary clause from SQL
alter tablespace <temp_tablespace>
add tempfile '<file_name>' size <size>
if your tablespace name is temporary let us know
"Poole David " <oracledba-ezmlmshield-x27905957.[Email address protected]
06/30/2005 06:39 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
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
--------
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