Shrink Temporary Tablespace

From: Steven <SPAMBLOCKERsteven.pannell_at_gmx.net>
Date: Fri, 26 Sep 2003 11:49:06 +0200
Message-ID: <bl122k$6uid5$1@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 - 04:49:06 CDT