Shrinking Undo Tablespace in Oracle 9i

[pareshg]

Hi all,

How to shrink Undo Tablespace in Oracle 9i.
My Undo Tablespace is increased to 3.2 G.
I know that Oracle will automatically shrink it after 10 hours, but is there any commands to shrink it?

Thanks

Paresh

[ggnanaraj]

Originally posted by pareshg
Hi all,

How to shrink Undo Tablespace in Oracle 9i.
My Undo Tablespace is increased to 3.2 G.
I know that Oracle will automatically shrink it after 10 hours, but is there any commands to shrink it?

Thanks

Paresh

Nope! you can't shrink a undo tbs as it is system managed. However, you could try a RESIZE on the concerned datafile and see.
http://download-west.oracle.com/docs.../undo.htm#9097


HTH.