| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-01562: failed to extend rollback segment
Hi,
You can also commit after every update.. instead of 500 records... and try...
OR
Increase ROLLBACK Segment Space...
HTH Nikunj
> The problem really is that you have run out of space on your tablespace
for
> this rollback segment. Either make the existing datafile for the rollback
> segment bigger or add an additional datafile to the rollback segment.
> Allan.
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Sunday, November 19, 2000 6:50 PM
>
>
> 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 = '200001';
> i number;
> begin
> i := 0;
> for rec in migra loop
> i := i + 1;
> if i > 500 then
> commit;
> i := 0;
> end if;
> update w_churseg_contratti_200001
> set churn_classe_cod = '001-03';
> end loop;
> commit;
> end;
> /
>
> thanks
> Antonio
>
 |
 |