Re: Oracle Error when writing, deleting large amounts of data

Steve Jelfs <s.jelfs_at_btinternet.com> writes:

>Matthew Chappee wrote:
>>
>> I get the following errors when writing or deleting large amounts of
>> data. It's starting to get really annoying. What can I do to fix
>> this?
>>
>> ORA-01562: failed to extend rollback segment number 8
>> ORA-01628: max # extents (121) reached for rollback segment RB7
>>
 

>1. Create new and/or bigger rollbacks

alter rollback storage definition (larger initial/next segment)

>2. Don't write or delete large amounts of data

>Sj
Received on Fri Feb 13 1998 - 00:00:00 CST