Re: Question: error on update

From: Sunder <sunder.nochilur_at_pcm.bosch.com>
Date: 1998/09/25
Message-ID: <01bde839$4066c9e0$230502aa@qaw4lap>#1/1

This means that you don't have sufficient space for the rollback segment. Try committing intermittently.

Sunder

badstreetboy_at_my-dejanews.com wrote in article <6ue1jk$nuh$1_at_nnrp1.dejanews.com>...
> I have a simple update statement like this:
>
> update t1 set f1 = 0;
>
> Then SQLPLUS gives me this err:
>
> ERROR at line 1:
> ORA-01562: failed to extend rollback segment number 2
> ORA-01650: unable to extend rollback segment R01 by 64 in tablespace RBS
>
> What does that mean? Thanks...
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Fri Sep 25 1998 - 00:00:00 CDT