This discussion is archived
5 Replies Latest reply: Feb 7, 2013 1:46 PM by 941744 RSS

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

941744 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points