5 Replies Latest reply: Feb 7, 2013 3:46 PM by 941744 RSS

    2 Undo Tablespace both ONLINE, How to drop previous undo tbs

    941744
      Hello Team,

      Undo management=auto

      After Cloning :-
      To reclaim space i created another undo tablespace, but now both are online, but as per oracle as soon as you switch undo tablespace, previous undo TBS gets in Pending offline mode,offline mode, (So that transaction get finished)

      But in my case Both UNDO Tablespaces are online

      Previous Undo TBS1:- 600 GB

      New UNDo Tb2s:- 100GB

      Please suggest how to drop this online undo TBS1

      TABLESPACE_NAME ONLINE_
      ------------------------------ -------
      APPS_UNDOTS1 ONLINE
      APPS_UNDOTS1 ONLINE
      APPS_UNDOTS1 ONLINE
      APPS_UNDOTS1 ONLINE
      APPS_UNDOTS1 ONLINE
      APPS_UNDOTS1 ONLINE
      APPS_UNDOTS1 ONLINE
      APPS_UNDOTS1 ONLINE
      APPS_UNDOTS1 ONLINE
      APPS_UNDOTS2 ONLINE
      APPS_UNDOTS2 ONLINE

      TABLESPACE_NAME ONLINE_
      ------------------------------ -------
      APPS_UNDOTS2 ONLINE