遇到oracle数据库回滚段满后的方法

遇到数据库回滚段满后

回滚段表空间占100%

重新启动数据库

重启动后，

alter rollback segment LARGE_TRANS shrink;

alter rollback segment LARGE_TRANS offline;

drop rollback segment LARGE_TRANS;

然后重新create

CREATE PUBLIC ROLLBACK SEGMENT "LARGE_TRANS"

TABLESPACE "LARGE_TRANS"

STORAGE ( INITIAL 1024K NEXT 128K);

ALTER ROLLBACK SEGMENT "LARGE_TRANS" ONLINE;

数据库环境：oracle server 7.2.3

系统环境：UnixWare test05 5 7.1.3 i386 x86at SCO UNIX_SVR5 25

 

本文地址：http://www.45fan.com/a/question/70313.html