Default Temporary Tablespace

From: William Wagman <wjwagman_at_ucdavis.edu>
Date: Mon, 5 Jan 2009 14:10:25 -0800
Message-ID: <2A8185DC02A8CE4C8413E0A26A8A831A01E5B284B5_at_XEDAMAIL2.ex.ad3.ucdavis.edu>



Greetings,

I'm running Oracle 10.2.0.4.0EE on RHEL4. Following Metalink note 273276.1 I resized the temporary tablespace in a test database. However, I was not paying attention and issued the command

SQL> alter database default temporary tablespace <new_temp_tablespace>;

although the temporary tablespace I was resizing was not the default temporary tablespace, the system tablespace was. Upon attempting to again make the system tablespace the default temporary tablespace I receive an ORA-12901 error...

SQL> alter database default temporary tablespace system; alter database default temporary tablespace system; *
ERROR at line 1:
ORA-12901: default temporary tablespace must be of TEMPORARY type

My question is are there potential problems with the system tablespace *not* being the default temporary tablespace? If so what are the potential problems and is there a way to restore the system tablespace as the default temporary tablespace short of rebuilding the database?

Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 05 2009 - 16:10:25 CST

Original text of this message