Re: Deleting 14 Lac rows

From: Access <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sun, 31 Oct 2004 20:33:03 +0100
Message-ID: <41853dee$0$25839$ba620e4c@news.skynet.be>

"Saurabh Pathak" <s.pathak_at_insightbb.com> wrote in message news:7m9hd.28522$HA.6987_at_attbi_s01...
> write a pl/sql blocak and do commit every 5000 rows is the only option ..
>
> Saurabh
> "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
>
>

Here's an example pl/sql script :

http://www.orafaq.com/scripts/plsql/plsloop.txt

HTH
Matthias Hoys Received on Sun Oct 31 2004 - 13:33:03 CST