FW: Default Temporary Tablespace

From: <oracle-l-bounce_at_freelists.org>
Date: Mon, 5 Jan 2009 16:19:27 -0600
Message-ID: <AD7C091172665E4387E4EBA18BFE01F008AAE626_at_USWIMS03.kohlerco.com>


 

-----Original Message-----
From: Blanchard William
Sent: Monday, January 05, 2009 4:19 PM
To: 'wjwagman_at_ucdavis.edu'
Subject: RE: Default Temporary Tablespace

Why would you want the System tablespace as the default temporary tablespace? ...or am I just Ignant?  

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of William Wagman Sent: Monday, January 05, 2009 4:10 PM
To: oracle-l
Subject: Default Temporary Tablespace

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


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

Original text of this message