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




Oracle LazyDBA home page