ORA-01562: failed to extend rollback segment

From: Antonio Idone <antoidone_at_visto.com>
Date: Sun, 19 Nov 2000 14:48:15 -0800
Message-Id: <10685.122464@fatcity.com>

Hi list,
i have folling problem:

Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.0, 64 bit - Production With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production

declare
*
ERROR at line 1:
ORA-01562: failed to extend rollback segment number 3 ORA-01650: unable to extend rollback segment RBS03 by 640 in tablespace DDS_RBS_02
ORA-06512: at line 13

---

The PL/SQL that do this is:

declare
 cursor migra is select row_id from zrp_update_churnati_rowid    where annomese_rif =3D '200001';
i number;
begin
i :=3D 0;
 for rec in migra loop
i :=3D i + 1;
if i > 500 then
commit;
i :=3D 0;
end if;
  update w_churseg_contratti_200001
  set churn_classe_cod =3D '001-03';
 end loop;
 commit;
end;
/

thanks
Antonio

_________________________________________________________________________=

__
Visit http://www.visto.com/info, your free web-based communications cente= Received on Sun Nov 19 2000 - 16:48:15 CST