Re: Deleting 14 Lac rows

Hi Amit,

I was wondering why you dont try the TRUNCATE TABLE command..

Regards
Brijesh Mathew
amit_at_billdesk.com (Amit Kaushal) 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
Received on Mon Nov 01 2004 - 13:21:17 CST