Re: Can't delete 60000 records at a time

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