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
Printable View
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.Quote:
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
http://download-west.oracle.com/docs.../undo.htm#9097
HTH.