Re: Shrink Temporary Tablespace

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 26 Sep 2003 14:51:44 GMT
Message-ID: <4oYcb.124397$bo1.77727@news-server.bigpond.net.au>

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:3f743a8c$0$32058$afc38c87_at_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.
>

Hi Howard,

You mean autoextend ?

Cheers ;)

Richard Received on Fri Sep 26 2003 - 09:51:44 CDT