Re: Shrink Temporary Tablespace

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Fri, 26 Sep 2003 23:06:28 +1000
Message-ID: <3f743a8c$0$32058$afc38c87@news.optusnet.com.au>

Steven wrote:

> 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,
>

An excellent demonstration of why autoallocate is a really bad idea!

Drop the temporary tablespace altogether and re-create it. And make sure autoallocate is not turned on this time.

Regards
HJR Received on Fri Sep 26 2003 - 08:06:28 CDT