ORA-01548: active rollback segment '_SYSSMU1_3724004606$' found, terminate dropping tablespace

背景：误删除Undo数据文件，新建Undo表空间后指向新的undo表空间，删除旧的undo表空间时报错

SQL> drop tablespace undotbs1 including contents and datafiles;
drop tablespace undotbs1 including contents and datafiles
*
ERROR at line 1:
ORA-01548: active rollback segment '_SYSSMU1_3724004606$' found, terminate
dropping tablespace

step1：查看回滚段的状态 -为needs recovery

Select segment_name, status, tablespace_name
  from dba_rollback_segs
 where status not in ('ONLINE', 'OFFLINE');

SEGMENT_NAME    STATUS    TABLESPACE_NAME
_SYSSMU1_3724004606$    NEEDS RECOVERY    UNDOTBS1
_SYSSMU2_2996391332$    NEEDS RECOVERY    UNDOTBS1
_SYSSMU3_1723003836$    NEEDS RECOVERY    UNDOTBS1
_SYSSMU4_1254879796$    NEEDS RECOVERY    UNDOTBS1
_SYSSMU5_898567397$    NEEDS RECOVERY    UNDOTBS1
_SYSSMU6_1263032392$    NEEDS RECOVE