You also could write a PL/SQL block to have a counter for the number of
records deleted and when it reaches a certain number, then commit and reset
the counter.
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)
mpir_at_compuserve.com wrote in article <6jul5j$9t4$1_at_nnrp1.dejanews.com>...
> Try recreating the rollback segments with larger extents. That way the
121
> limit won't be as limiting.
>
> You might consider a special big rollback segment for use only when you
do
> the large delete. Create it in it's own tablespace, leave it offline
when
> not in use. When you need it, alter it online and use 'set transaction
use
> rollback segment bigone;'
>
>
>
> In article <alex-1905981230250001_at_208.21.174.26>,
> alex_at_webis.net (Alex Kac) wrote:
> >
> > I have a database where I need to delete only 60,000 records at once,
but
> > I keep on getting an error like:
> >
> > ERROR at line 1:
> > ORA-01562 failed to extend rollback segment number 6
> > ORA-01628 max # of extents (121) reached for rollback segment RB5
> >
> > I've looked in the manual and have done the procedures it talked about
but
> > I still can't get the extents above 121, or the unlimited_extents flag
to
> > true. I can delete the database in small segments, but at the point I
am
> > deleting the last 20000, I have to actually restart the whole machine
to
> > delete that last bit piece by piece...i.e. it won't let me even delete
> > 1000 records.
> >
> > Any ideas would be very helpful!
> >
> > I lurk in this newsgroup a few times a week, so an email followup would
be
> > appreciated: alex_at_webis.net
> >
>
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Wed May 20 1998 - 00:00:00 CDT
