> 
> I got the following error:
> 
>  ORA-01555: snapshot too old (rollback segment too small) : errno -1555:
> 
> 	I have 10 rollback segments, each identical in design 
>         (initail 128K, next 128K, optimal 256K)
> 	And I have 2 rbs tablespaces, the first 50M, the next 100M.
> 	What do I need to increase?
> 		
> 		Thanks in advance,
> 			Christine
Christine,

You need to increase either the INITIAL, NEXT, or both. What is happening is
one process, attached to one rollback segment, took too much data for
one rollback segment to keep the process's view of the data in a consistent mode.

So, drop all rollback segments and recreate. For starters, try:

INITIAL 1M
NEXT 1M
OPTIMAL 2M
MINEXTENTS 2


Best of luck,


-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 150+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page ck to Ari Kaplan's Home Page