Re: Shrink Temporary Tablespace

"KL" <klewan01_at_poczta.onet.pl> wrote in message news:bl19ra$gb$1_at_korweta.task.gda.pl...
> try something like this:
>
> SQL> alter database tempfile 'filename' resize 50M;
>

Not possible when using Local Managed temp tablespaces. It does not work. Would appear the only way is to drop and recreate the datafile.

Steve.

> K.
>
> Użytkownik "Steven" <SPAMBLOCKERsteven.pannell_at_gmx.net> napisał w
 wiadomości
> 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,
> >
> > --
> > -----------------------------------------------------------------
> > Holidays in Berchtesgaden, Germany:
> > http://pension-berchtesgaden.de
> >
> >
>
>
Received on Fri Sep 26 2003 - 08:06:54 CDT