删除回滚段

alter system set undo_tablespace ' ';

--无法删除使用中的回滚段

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

--更改模式，删除，还是不行

SQL> alter system set "_smu_debug_mode"=4;

SQL> alter rollback segment "_SYSSMU19_2953468496$" offline;
alter rollback segment "_SYSSMU19_2953468496$" offline
*
ERROR at line 1:
ORA-01598: rollback segment '_SYSSMU19_2953468496$' is not online


SQL> drop rollback segment "_SYSSMU19_2953468496$";
drop rollback segment "_SYSSMU19_2953468496$"
*
ERROR at line 1:
ORA-01545: rollback segment '_SYSSMU19_2953468496$' specified not available

产看会滚段的占用

select * from dba_rollback_segs where segment_name='_SYSSMU19_2953468496$';

---使用pfile启动

SQL> create pfile='/app/u02/oracle/init.ora' from spfile;

--增加隐含参数
_offline_rollback_segments=(_SYSSMU19_2953468496$)
_corrupted_rollback_segments=(_SYSSMU19_2953468496$)

SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup mount pfile='/app/u02/oracle/init.ora';
ORACLE instance started.

--删除刚才占用的回滚段

SQL> drop rollback segment "_SYSSMU19_2953468496$";

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25223017/viewspace-710213/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25223017/viewspace-710213/