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

Thread: Reduce size or recreate undo tablespace

  1. 07-14-2003, 03:51 AM #1
    richyip
    richyip is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 07-14-2003, 04:07 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    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!
    Reply With Quote Reply With Quote
  3. 07-14-2003, 06:07 AM #3
    richyip
    richyip is offline Junior Member
    Join Date
    Apr 2003
    Location
    Kuala Lumpur
    Posts
    59
    jovery,

    For no.2, how to change the 'undo_tablespace' parameter to new tablespace? Tks.
    Reply With Quote Reply With Quote
  4. 07-14-2003, 06:15 AM #4
    akhadar
    akhadar is offline Advisor
    Join Date
    May 2001
    Posts
    736
    Alter system set undo_tablespace = new undo_tablespace
    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