Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback

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.

jg

--
@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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US