Re: ORA 1562 Rollback segment problem

In article <3o34eb$3ds_at_athos.cc.bellcore.com>, parris_at_walleye.esp.bellcore.com says...
>
>Hi,
> I have defined the table space for Rollback segments to a size
> of 4M. Our Product Test folks running a particularly large
 transaction,
> got ORA 1562. The transaction sometimes works and sometimes
 doesn't.
> In looking at the four segment sizes:
> RB1 532K
> RB2 665K
> RB3 2.5M
> RB4 400K
> Can anyone have a clue as to why the transaction sometimes
 fails?
> 4M seems like it should be enough space. Given that I'm in the
> situation, what is the best way now to get out?
>
> HP-UX with Oracle 7.0.16.4
>
> Thanks.

The transaction is probably failing when it uses a small rollback segment (RB1, RB2, or RB4) and is working when it is using the large rollback segment (RB3). You are able to define exactly which rollback segment you wish to use, when you begin the transaction.

Thanks. Received on Wed May 03 1995 - 00:00:00 CEST