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


Oracle LazyDBA home page