Re: shrinking undo tablespace

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Fri, 21 Jun 2002 08:44:21 +1000
Message-ID: <aetlt5$m96$1@lust.ihug.co.nz>

Assuming you are therefore using the proper 'tempfile' type of temporary tablespace, the command is:

alter database tempfile 'D:\ORACLE\ORA92\DB9\TEMP01.DBF' resize 80m;

(Pick a size to suite. Normal rules apply: if getting to the new size would result in real data being chopped off, it won't work).

Regards
HJR "sg" <s4v4g3_at_europe.com> wrote in message news:3D1256D3.1050707_at_europe.com...
> sorry forgot the version number..... it's 9.2
>
> Howard J. Rogers wrote:
>
> > Version?
> >
> > HJR
> >
> > "sg" <s4v4g3_at_europe.com> wrote in message
news:3D125536.40305_at_europe.com...
> >
> >>Hi
> >>
> >>Does anyone know how to shrink an undo tablespace? So far the only way I
> >>can find is by create a new one and drop the old one!
> >>
> >>Any other way?
> >>
> >>
> >
> >
>
Received on Thu Jun 20 2002 - 17:44:21 CDT