sos:oracle 8 ora-01562 等错误,请指教.

[billcsh]

我想测试数据查询时间,在net8中新加入100000条记录,但出错如下,请指教.
SQL> declare
2 vemp char(6);
3 vdpt char(2);
4 vsex char(1);
5 begin
6 for i in 1..100000 loop
7 select decode(mod(i,3),0,'01',1,'01',2,'02',3,'03') into vdpt from dual ;
8 select decode(mod(i,2),0,'0',1,'1') into vsex from dual;
9 vemp:=lpad(to_char(i),5,'0');
10 insert into emp(deptno,empno,empname,sex) values(vdpt,vemp,vemp,vsex);
11 end loop;
12 end ;
13 /
declare
*
第1行有错:
ORA-01562: 扩展重算段号2失败
ORA-01628: 已达到 max # extents (121)（重算段RB0）
ORA-06512: 在line 10

[wumugulu]

01562, 00000, "failed to extend rollback segment number %s"
// *Cause: Failure occurred when trying to extend rollback segment
// *Action: This is normally followed by another error message that caused the failure. You may take the rollback segment offline to perform maintainence. Use the alter rollback segment offline command
to take the rollback segment offline.

[jlandzpa]

回滚段小，分段提交吧.

[mycode]

回退段太小，一次插入的数据太多。
建议扩大回退段，分段提交。