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

Thread: UNDO Tablespaces

  1. #1
    Join Date
    Jun 2001
    Posts
    243

    UNDO Tablespaces

    I would like to switch using Rollback Segments to use Undo RBS on 9i. Should I create Undo Tablespaces in 9i and then remover old Rollback Segments? and UNDO_MANAGEMENT =TRUE...and...do I need anything else?

  2. #2
    Join Date
    Sep 2002
    Posts
    12
    Create the undo tablespace (only one)
    Set UNDO_MANAGEMENT = AUTO
    Set UNDO_TABLESPACE =

    Bounce the database

    At this time you can get rid of the tablespace containing the rbs

    Corrado
    Corrado Mascioli

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