Your temporary tablespace is named "TEMPORARY"? I figured that *had* to be
a reserved word, but apparently not.
I just created a temporary tablespace called "TEMPORARY", and added a
tempfile with no problems. I used Oracle9i on Windows 2000 Professional:
SQL> create temporary tablespace temporary tempfile 'c:\tmp\temporary.dbf'
size 10m;
Tablespace created.
Elapsed: 00:00:07.07
SQL> alter tablespace temporary add tempfile 'C:\TMP\TEMPORARY2.dbf' size
10m;
Tablespace altered.
Elapsed: 00:00:07.04
SQL>
-----Original Message-----
From: Poole David
[mailto:oracledba-ezmlmshield-x27905957.[Email address protected]
Sent: Thursday, June 30, 2005 9:10 AM
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
**************************************************************************************
The information contained in this email is privileged and confidential information intended only for the use of the individual or entity named as recipient. If the reader is not the intended recipient, please be notified that any dissemination, distribution, or copy of this communication is strictly prohibited. If you have received this communication in error, please do not disclose this communication to any other person. Please notify us immediately by telephone and return the original to us at the address indicated above. Thank you
Oracle LazyDBA home page