Convert rollback segments to undo tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Convert rollback segments to undo tablespace

  1. #1
    Join Date
    Jan 2001
    Posts
    216

    Convert rollback segments to undo tablespace

    Are there any gotchas I need to be aware of when converting a database using rollback segments into using undo tablespace in Oracle 9i?

    I think the steps to be followed are: Am I missing anything?

    1. Find all rollback segments
    select segment_name, tablespace_name from dba_rollback_segs;

    2. Drop all except for system
    alter rollback segment offline;
    drop rollback segment ;

    3. Drop rollback tablespace
    alter tablespace RBS offline;
    drop tablespace RBS;

    4. Create the new undo tablespace
    create undo tablespace APPS_UNDOTS1 datafile '' size reuse extent management local ;

    5. Add undo_management = AUTO and undo_tablespace = APPS_UNDOTS1 to init.ora and comment out the rollback_segs parm

    6. Bounce the database and take a backup

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Move steps 1, 2 and 3 after step 6. It should be 4,5,6,1,2,3.

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Jan 2001
    Posts
    216
    Thanks, I will give it a shot.

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