Oracle8i回滚段表空间的坏块

核心提示： 然后做个drop回滚段的脚本:SQL>? select 'drop rollbacksegment '||segment_name||';' from dba_rollback_segs;drop rollback segment RBS0;drop

然后做个drop回滚段的脚本:

SQL>? select 'drop rollback
segment '||segment_name||';' from dba_rollback_segs;
drop rollback segment RBS0;
drop rollback segment RBS1;
drop rollback segment RBS2;
drop rollback segment RBS3;
drop rollback segment RBS4;
drop rollback segment RBS5;
drop rollback segment RBS6;
drop rollback segment RBS7;
drop rollback segment RBS8;
drop rollback segment RBS9;
drop rollback segment RBS10;
drop rollback segment RBS11;
drop rollback segment RBS12;
drop rollback segment RBS13;
drop rollback segment RBS14;
drop rollback segment RBS15;
drop rollback segment RBS16;
drop rollback segment RBS17;
drop rollback segment RBS18;
drop rollback segment RBS19;
drop rollback segment RBS20;
drop rollback segment RBS21;
drop rollback segment RBS22;
drop rollback segment RBS23;
drop rollback segment RBS24;
drop rollback segment RBS25;
drop rollback segment RBS26;
drop rollback segment RBS27;
drop rollback segment RBS28;
drop rollback segment APPRBS;

脚本做好了，执行。

执行完后开始在新的回滚段表空间下建回滚段，存储参数和原来保持一致：

SQL> select? 'create public rollback
segment '||segment_name||' tablespace rbs01 storage
(initial 524288 next 524288 MINEXTENTS 8
MAXEXTENTS 4096 OPTIMAL 4194304); from dba_rollback_segs;