Re: ORA-01562: failed to extend rollback segment

From: Allan Davis Sahadeo <asahadeo_at_neal-and-massy.com>
Date: Sun, 19 Nov 2000 19:47:22 -0400
Message-Id: <10685.122466@fatcity.com>

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 -----

From: "Antonio Idone" <antoidone_at_visto.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, November 19, 2000 6:50 PM
Subject: ORA-01562: failed to extend rollback segment

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

Visit http://www.visto.com/info, your free web-based communications center. Visto.com. Life on the Dot.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Antonio Idone
INET: antoidone_at_visto.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sun Nov 19 2000 - 17:47:22 CST