FW: Default Temporary Tablespace
Date: Mon, 5 Jan 2009 16:19:27 -0600
From: Blanchard William
Sent: Monday, January 05, 2009 4:19 PM
Subject: RE: Default Temporary Tablespace
Why would you want the System tablespace as the default temporary tablespace? ...or am I just Ignant?
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of William Wagman Sent: Monday, January 05, 2009 4:10 PM
Subject: Default Temporary Tablespace
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?
Univ. of California at Davis
IET Campus Data Center