RE: Temporary Tablespaces

  • From: "Hollis, Les" <Les.Hollis@xxxxxx>
  • To: <mark@xxxxxxxxx>, <bunjibry@xxxxxxxxx>
  • Date: Sun, 9 Jan 2005 13:06:44 -0600

What version?  Are you using "default" temporary tablespace if on 9i?






-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mark J. Bobak
Sent: Sunday, January 09, 2005 12:36 PM
To: bunjibry@xxxxxxxxx
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 that
created in #4.
6.)  Drop tablespace created in #1.

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@xxxxxxxxx
"Science is the belief in the ignorance of experts."  --Richard P.
Feynman


--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

Other related posts: