Re: Deleting 14 Lac rows

From: Dave <x_at_x.com>
Date: Sun, 31 Oct 2004 17:28:54 GMT
Message-ID: <qh9hd.20498$cn.8447@fe1.news.blueyonder.co.uk>

"Amit Kaushal" <amit_at_billdesk.com> wrote in message news:4c63c8fc.0410310754.35cbbc61_at_posting.google.com...
> Hi,
>
> I have an oracle 8.0.6 database running on solaris 2.6
>
> I have to delete 14 lac rows from a table. When i begin deleting,
> after some time i get an error accordin to which my rollback segments
> have run out of space.
> How do i do a commit say after every 5000 rows have been deleted.
>
> I do not want to drop the segments and create a new one and then
> assign the delete transaction to the new rbs.
>
> Pls advice
> TIA
> amit kaushal

whats a lac? Received on Sun Oct 31 2004 - 11:28:54 CST