Re: Question: error on update

In your update you do not have a where statement. This causes the entire table to be updated and all these changes have to be logged in a rollback segment so that they can be undone if a rollback is performed. If the table is very large then you can run out of space.

Patrick Flahan
flahan_at_earthlink.net

<badstreetboy_at_my-dejanews.com> wrote in message 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