Re: [Q]Delete error?

From: Winnie Liu <poohland_at_hotmail.com>
Date: Sun, 12 Jul 1998 11:36:20 -0700
Message-ID: <6oavf9$q6o@sjx-ixn9.ix.netcom.com>

Your rollback segment is too small to handle the delete. Try to use PL/SQL program and commit the transaction frequently or assigned a rollback segment especially for this transaction.
>Set transaction use rollback segment <rollback segment name>
remember to type this line right before your transaction.

Winnie Liu

kimcd_at_shinbiro.com wrote in message <35a93eae.1668751_at_news.shinbiro.com>...
>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
>
Received on Sun Jul 12 1998 - 13:36:20 CDT