Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Temporary Tablespaces
What version? Are you using "default" temporary tablespace if on 9i?
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark J. Bobak
Sent: Sunday, January 09, 2005 12:36 PM
To: bunjibry_at_gmail.com
Cc: Oracle-L Mailing List
Subject: Re: Temporary Tablespaces
Bryan,
1.) Create *temporary* TEMPORARY tablespace.
2.) Loop through all users, alter user ... reset temp tablespace to
that created in #1.
3.) Drop current temp tablespace. 4.) Create the temp tablespace in the new target disk. 5.) Loop through all users, alter user ... to reset the temp space thatcreated in #4.
But, before you do all that, have you considered whether this is really going to increase performance? How did you come to that conclusion?
-Mark
On Sun, 2005-01-09 at 12:55, Bryan Wells wrote:
> Okay... I want to improve some disk space by moving temporary
> tablespaces to another physical disk, however, im thinking I cant do
> this w/o dropping and recreating since i cant take a temporary
> tablespace offline to move it. ora can I?
-- Mark J. Bobak mark_at_bobak.net "Science is the belief in the ignorance of experts." --Richard P. Feynman -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Sun Jan 09 2005 - 13:02:33 CST
![]() |
![]() |