Reduce size or recreate undo tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Reduce size or recreate undo tablespace

  1. #1
    Join Date
    Apr 2003
    Location
    Kuala Lumpur
    Posts
    59

    Reduce size or recreate undo tablespace

    Hi,

    I notice that my UNDO datafile has grown from 200MB to 1GB. I tried to reduce the size but it doesn't allow. How can I strink the file back to 200MB or drop and recreate back? I'm not allow to offline the tablespace and thus cannot delete.

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    To recreate:

    1. Create a new undo tablespace
    2. Change the 'undo_tablespace' parameter to the new tablespace name.
    3. Drop the old tablespace (obviously you will have to have no active transactions in this tablespace before you can do this)
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Apr 2003
    Location
    Kuala Lumpur
    Posts
    59
    jovery,

    For no.2, how to change the 'undo_tablespace' parameter to new tablespace? Tks.

  4. #4
    Join Date
    May 2001
    Posts
    736
    Alter system set undo_tablespace = new undo_tablespace

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