-
Shrinking Undo Tablespace in Oracle 9i
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
-
Re: Shrinking Undo Tablespace in Oracle 9i
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|