Re: Question: error on update

This means the rollback segment R01 can't be extended anymore, either because of there is unsufficient free space in the tablespace, or maxextents of the rollback segment has been reached. In the first case you need to find out whether or not the tablespace is full: select bytes from dba_free_space where tablespace_name = 'RBS' and possible resize or extend the tablespace In the other case you can change maxextents of the rollback segment. Hth,
Sybrand Bakker, Oracle DBA

badstreetboy_at_my-dejanews.com wrote:

> 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 Thu Sep 24 1998 - 00:00:00 CEST