Re: Large deletions.

Hi

You can do as Mike suggested.

Other wise.

If you are using Oracle 7.3 or higher.

Step1 Create a rollback segment Rbtest (Or if you want to use existing one take it off-line and do below steps)

Step 2 Increase the Max extents of Rbtest 605 (usually Multiples of 121 or more)

Step 3 Make it On-line

 When ever you want to delete

Step 4 type SET TRANSACTION USE ROLLBACK SEGMENT RBTEST;

You can keep this in a script and execute.

Hope by either ways you can solve your problem.

In article <ustz2.9110$0p5.3473_at_news.rdc1.md.home.com>,   "Mike Rose" <mmrose_at_home.com> wrote:
> 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
> >
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 22 1999 - 09:22:29 CET