ORA-01548删除undo表空间处理

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

SQL> select SEGMENT_NAME,TABLESPACE_NAME,STATUS from dba_rollback_segs WHERE TABLESPACE_NAME='SHENG_UNDO';

SEGMENT_NAME                   TABLESPACE_NAME                STATUS
------------------------------ ------------------------------ ----------------
_SYSSMU11_1810834595$          SHENG_UNDO                     NEEDS RECOVERY
_SYSSMU12_2190166586$          SHENG_UNDO                     NEEDS RECOVERY
_SYSSMU13_2650662840$          SHENG_UNDO                     NEEDS RECOVERY
_SYSSMU14_3436632023$          SHENG_UNDO                     NEEDS RECOVERY
_SYSSMU15_535471449$           SHENG_UNDO                     NEEDS RECOVERY
_SYSSMU16_4089783446$          SHENG_UNDO                     NEEDS RECOVERY
_SYSSMU17_887370296$           SHENG_UNDO                     NEEDS RECOVERY
_SYSSMU18_1072439456$          SHENG_UNDO                     NEEDS RECOVERY
_SYSSMU19_614170081$           SHENG_UNDO                     NEEDS RECOVERY
_SYSSMU20_864501969$           SHENG_UNDO                     NEEDS RECOVERY

10 rows selected.

spfile设置相关参数就可：
_offline_rollback_segments=
(_SYSSMU11_1810834595$,_SYSSMU12_2190166586$,_SYSSMU13_2650662840$,_SYSSMU14_3436632023$,_SYSSMU15_535471449$,_SYSSMU16_4089783446$,
_SYSSMU17_887370296$,_SYSSMU18_1072439456$,_SYSSMU19_614170081$,_SYSSMU20_864501969$)