Rollback segment too small (-1555)
From: <Stephen>
Date: 1996/05/08
Message-ID: <4mp0gr$1kn_at_uuneo.neosoft.com>#1/1
Date: 1996/05/08
Message-ID: <4mp0gr$1kn_at_uuneo.neosoft.com>#1/1
Often when extracting large volumes of data from an Oracle table I recieve the message:-
Rollback segment too small -1555
This occurs even though I'm doing a select against the table and there are no other processes updating the table and activity on the
database as a whole is light. We have 8 rollback segments each 1/2 gig in size. How can this be and what can I do to prevent it ? Is
there a FAQ out there somewhere which addresses this issue ?
Thanks
Stephen Kirk