Re: [Q] Delete error?

In article <35a83e77.1613803_at_news.shinbiro.com>, kimcd_at_shinbiro.com wrote:
>What's mean?
>Must I do?
>"
> 1* delete from headers where s_time<'19971231'
>SQL> /
>delete from headers where s_time<'19971231'
> *
>ERROR at line 1:
>ORA-01562: failed to extend rollback segment (id = 15)
>ORA-01650: unable to extend rollback segment R03 by 2560 in tablespace
>RBS
Your rollback segment is too small for the transaction. Do you have a bigger one? If so you might try... SQL> set transaction use rollback_segment NAME_OF_BIG_ONE;

If not, is the RBS tablespace too small? Contact your DBA.

If this is a one time deal, the really low tech solution is:

begin

        loop
                delete from headers
                 where s_time<'19971231
                    and rownum < 10000;
                commit;
        end loop;
exception
        when others then commit;

If this is part of some regular processing, such as periodic purge activity, then do yourself and your DBA a favor - talk to them about how to do this efficiently.

-OraSaurus Received on Mon Jul 13 1998 - 05:24:09 CEST