Re: Shrink Temporary Tablespace

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 26 Sep 2003 10:02:27 -0700
Message-ID: <1efdad5b.0309260902.2c9b775a@posting.google.com>

"Steven" <SPAMBLOCKERsteven.pannell_at_gmx.net> wrote in message 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,

isnt the proper method to creaet another temp tablespace and then point to it in the init.ora? not sure if you have to bounce the db for this or not. Received on Fri Sep 26 2003 - 12:02:27 CDT