Re: Error in Rollback Segment

If it were me I'd increase the size of the tablespace containing rollback segments

rspeaker_at_my-deja.com wrote:

> the message is occurring because your rollback segments are not large
> enough to handle the amount of DML that is occurring. You have a couple
> of options:
>
> increase the size of all your rollback segments and let the data refresh
> randomly hit a rollback segment;
>
> create a single large rollback segment with larger extent settings in a
> separate tablespace, and use the SET TRANSACTION USE ROLLBACK SEGMENT
> RBSLARGE at the beginning of your data refresh;
>
> or alter your data refresh application and add the SET AUTOCOMMIT xxx to
> the beginning to force periodic commits during the refresh. This will
> keep large amounts of DML from clogging up the rollback segment.
>
> If it were me, I would choose option #2 (providing you have sufficient
> disk space) as my first preference.
>
> HTH,
> Roy
>
> In article <8537gv$jtj$1_at_nnrp1.deja.com>,
> xo55ox_at_hotmail.com wrote:
> > Hi,
> >
> > I ran into a rollback segment problem when I tried to refresh a
> database
> > data by moving tables through an application tool. An error message
> > popped up, "unable to extend rollback segment R04 by 400 in tablespace
> > PSRBS".
> > Then, I tried to do a smaller amount of table move. Pretty much the
> same
> > message came up with a different rollback segment.
> >
> > What should I do in order to solve the problem???
> >
> > Thanks in advance for any information.
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jan 10 2000 - 20:15:29 CST