Re: free temp tablespace

From: spencer <spencerp_at_swbell.net>
Date: Tue, 8 Feb 2000 21:56:05 -0600
Message-ID: <8z5o4.1478$9p3.41976@news.swbell.net>

i thought that on Oracle 8, extents in a TEMPORARY tablespace would not be deallocated until the instance is shutdown. this was a change to improve performance by avoiding unnecessary de-allocation and re-allocation of extents within the temporary segment.

i haven't tried taking the temporary tablespace offline before...

"Ray Stell" <stellr_at_stell.cns.vt.edu> wrote in message news:87q49m$ald$1_at_solaris.cc.vt.edu...
>
> 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.
Received on Tue Feb 08 2000 - 21:56:05 CST