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

On 06-Feb-98 16:28:11 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
 

>Thanks,
 

>Matthew

You'll have to create a big rollback segment using

create rollback segment rb_big ...

with large values for 'initial extent' and 'next extent'. (Check the manual for the exact syntax. I have neither manual nor Oracle here at home to check)
Then you can issue

set transaction use rollback segment rb_big;

to use this very rollback segment. If you do not want to use the 'set transaction', you will have to make all rollback segments large enough to store your transaction.

BTW: You can do an

     alter rollback segment rb7 shrink;
     alter rollback segment rb7 storage (next 10M);

     to enlarge rb7. So there is no need to create a new one.

Hope that helps,
Lothar

--
Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |