Re: free temp tablespace

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 09 Feb 2000 18:32:47 +0800
Message-ID: <38A1424F.66C2@yahoo.com>

Ray Stell wrote:
>
> The temp tablespace is full. How can I free space
> without causing heartache. I found somewhere
> it was said:
>
> > alter tablespace temp offline;
> > alter tablespace temp online;
> >
> > That will clear up the temporary tablespace for you.
>
> But this makes the young dba nervous.

You can achieve the same with

alter tablespace temp default storage ( pctincrease x);

where 'x' is what it already was. This should ease the nerves. But also remember that if the tablespace is set to TEMPORARY (as it should be) then it was often look "full" since Oracle leaves segments there for re-use by others.

HTH
--

---

Connor McDonald
connor_mcdonald_at_yahoo.com

There are 3,434,679 oracle websites around the world. Now there is one more... http://www.oracledba.co.uk Received on Wed Feb 09 2000 - 04:32:47 CST