Re: Shrink Temporary Tablespace

try something like this:

SQL> alter database tempfile 'filename' resize 50M;

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:03:04 CDT