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: Error in Rollback Segment

Re: Error in Rollback Segment

From: Zhuang Jiong <zjio_at_etb.bel.alcatel.be>
Date: Fri, 7 Jan 2000 12:59:33 +0100
Message-ID: <3876b70e.0@dnews.sbell.com.cn>


Try alter rollback segment with a bigger MAXEXTENTS parameter.

xo55ox_at_hotmail.com wrote in message <8537gv$jtj$1_at_nnrp1.deja.com>...
>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.
Received on Fri Jan 07 2000 - 05:59:33 CST

Original text of this message

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