DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Remove UNDO tablespace

    How can I delete the existing UNDO tablespace and create a new one? I have tried creating a new one, and then offline the default UNDO, but it says its current in use. I'm using OEM. Thanks.

  2. #2
    Join Date
    May 2001
    After creating the new undo tablespace
    Alter system set undo_tablespace = xxx;

    If there are any transactions using the old undospace let it continue and once these transactions are completed u can drop the old one.
    To determine any pending transaction use the following query

    sql>Select a.name,b.status
    from v$rollname a,v$rollstat b
    where a.name IN ( select segment_name
    from dba_segments where tablespace_name = 'undotbs')
    and a.usn = b.usn;

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