Re: [Q]Delete error?

From: Willem Kuijk <willem.kuijk_at_wxs.nl>
Date: Sun, 12 Jul 1998 13:57:33 +0200
Message-ID: <6oa7ok$b6822@reader1.wxs.nl>

Possibly this is wrong: your rollback segment is to small to hold te large transaction in the delete, caused by a large number of rows. You have to: enlarge your rollback segment, or (which is better), split up your delete in several smaller transactions, maybe by writing an pl/sql block in which you commit after deletion of every 1000 rows or so.

Good luck

Willem Kuijk

kimcd_at_shinbiro.com heeft geschreven in bericht <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 - 06:57:33 CDT