DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Shrinking Undo Tablespace in Oracle 9i

  1. 08-22-2003, 05:01 AM #1
    pareshg
    pareshg is offline Member
    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
    Reply With Quote Reply With Quote
  2. 08-22-2003, 05:39 AM #2
    ggnanaraj
    ggnanaraj is offline Senior Advisor
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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