Re: Large deletions.

From: Mike Rose <mmrose_at_home.com>
Date: Sat, 20 Feb 1999 07:26:18 GMT
Message-ID: <ustz2.9110$0p5.3473_at_news.rdc1.md.home.com>


[Quoted] A method that I've used successfully many times is to only delete part of the
records then commit --- repeat as necessary.

delete from table1 where not_unique_id < 10000 AND ROWNUM < 2500 COMMIT
delete from table1 where not_unique_id < 10000 AND ROWNUM < 2500 COMMIT
delete from table1 where not_unique_id < 10000 AND ROWNUM < 2500 COMMIT
delete from table1 where not_unique_id < 10000 AND ROWNUM < 2500 COMMIT Mike Rose

Erik Ulven wrote in message <36CD677E.2349F72D_at_quasar.no>...
>Hello out there.
>
>I have a problem. We need to delete pretty much data from our
>application. The syntax is simple:
>i.e:
>
>delete from table1 where not_unique_id < 10000;
>
>The rollbac segments goes full, and i dont want to expand the rollback
>segments all the time.
>Is there a way to make oracle commit during this deletion, or another
>good solution? Or do i have to
>delete in intervalls which takes alot of time??
>
>Thanks,
>
>erik
>
Received on Sat Feb 20 1999 - 08:26:18 CET

Original text of this message