Re: Shrink Temporary Tablespace

From: Vincento Harris <wumutek_at_yahoo.com>
Date: 26 Sep 2003 07:31:17 -0700
Message-ID: <2fa13ee7.0309260631.57212898@posting.google.com>

"Steven" <SPAMBLOCKERsteven.pannell_at_gmx.net> wrote in message news:<bl122k$6uid5$1_at_ID-82797.news.uni-berlin.de>...
> Hi,
>
> One of my users ran an incorrect query and increased the temporary
> tablespace to it's maximum of 4GB. Until now it was static around 400MB. I
> want to shrink the temporary datafiles back to their normal size but I can't
> seem to do this. It's won't allow me to.
>
> I'm using Oracle 9i with Locally managed temporary tablespaces.
>
> Is is possible now to shrink the datafiles. If so does anyone know how I
> can do this?
>
> Thanks in advance
> Steve,

Alter tablespace offline and online
Change the value of pctincrease in my case(from 1 to zero back to one) If you can find the root cause of the problem

Vince Received on Fri Sep 26 2003 - 09:31:17 CDT