Re: Deleting 14 Lac rows

From: Oradba Linux <techiey2k3_at_comcast.net>
Date: Mon, 01 Nov 2004 23:55:39 GMT
Message-ID: <%1Ahd.44199$R05.37456@attbi_s53>

"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

http://asktom.oracle.com/pls/ask/f?p=4950:8:16761203889186042343::NO::F4950_ P8_DISPLAYID,F4950_P8_CRITERIA:2345591157689, Follow what tom says, you will not be disappointed. Received on Mon Nov 01 2004 - 17:55:39 CST