Re: Rollback segment too small (-1555)
Date: 1996/05/09
Message-ID: <4mt224$rqn_at_tin.monsanto.com>#1/1
In article <4mp0gr$1kn_at_uuneo.neosoft.com> Stephen Kirk wrote:
> 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
>
>
This error message can sometimes occur if your temporary segment(s) are too small (for sorting). Check your temporary tablespace size.
Mike Corum
Technical Consulting Group
COTE
Monsanto Co
(All opinions my own...)
Received on Thu May 09 1996 - 00:00:00 CEST