Shrinking Undo Tablespace in Oracle 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Shrinking Undo Tablespace in Oracle 9i

  1. #1
    Join Date
    May 2001
    Location
    London
    Posts
    149

    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

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    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
  •  



Click Here to Expand Forum to Full Width