Results 1 to 5 of 5

Thread: undo tablespace

  1. #1
    Join Date
    Sep 2004
    Posts
    3

    Unanswered: undo tablespace

    The size of the undo tablespace has been increased considerably and donno how to reestablish its size.
    Shrink command it's only for rollback segment.
    I create new undo tablespace and switch for it.
    Somebody know another solution?
    thanks in advance ...

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Check out the following for a discussion of this very issue.

    http://asktom.oracle.com/pls/ask/f?p...:6894817116500
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Yes create new undo tablespace with AUTOEXTEND OFF option.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  4. #4
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    To shrink undo you have to swap it with a new undo tablespace see http://www.labo-oracle.com/tips/admi...s_78533_1.html.

    You can also specify a max size for autoextend on datafiles.

    Alan

  5. #5
    Join Date
    Sep 2004
    Posts
    3
    Thanks for links .. very good ..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •