var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: unable to delete undo tbsp
Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit
Old undo tbsp UNDOTBSP1
New undo tbsp UNDOTBSP2
New undo tbsp is active. Not able to delete old undo tbsp as it has one rollback segment as partly available
i not worreid about the data in that rollback segment i have want to delete and drop undo tbsp1.
OWNER SEGMENT_NAME TABLESPACE_NAME STATUS
PUBLIC _SYSSMU3_1723003836$ UNDOTBS1 PARTLY AVAILABLE
see the following link to see how to take care of it
You do not need a parachute to skydive. You only need a parachute to skydive twice.