Re: shrinking undo tablespace

I am aware of that command however I mean undo tablespace not temporary tablespace, for example if somehow my undo increases to a very big size how can I reduce it? In RBS we could shrink manually then reduce tablespace size but in 9i this seems very hard, or we have to wait SMON wakes up and frees up extents or we have to drop the undo tablespace and create a new one. Are there any more options?

Howard J. Rogers wrote:

> 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
>>>

>>>>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?
>>>>
>>>>
>>>>
>>>