Re: Rollback

From: Joel Garry <joel-garry_at_home.com>
Date: 1 Dec 2005 17:00:05 -0800
Message-ID: <1133485204.999236.196240@z14g2000cwz.googlegroups.com>

>ORA-01628: max # extents (121) reached for rollback segment OBVIOUS3

Ouch. Looks like you are using a small (2K) blocksize. You need to get in there to look at the code and make modifications to delete just a few rows at a time, or else create a large rollback segment and set all purge transactions to it. That will get you through the purge, then you probably need some administrative work to continue on.

The Oracle Press books Tuning Oracle by Corey and Abbey and the Complete Reference might get you going, if they are still in print for 8i.

--
@home.com is bogus.
http://www.usatoday.com/news/opinion/editorials/2005-11-29-wikipedia-edit_x.htm

Received on Thu Dec 01 2005 - 19:00:05 CST