Re: Disabling Rollback segments

Gary Wong wrote:
>
> I am trying to disable a transaction from using rollback. I am
 updating a
> large temp table with a single update statement and the
 rollback segments
> are too small to handle it.
>
> Is there a why to do this?
>
> Thanks in advance.

Gary,
Create one large rollback segment, public might be the quickest, as you have to edit your init.ora and bounce the database for private rb segments. As the first line of your transaction execute

set transaction use rollback segment <your rollback segment name>

This should do the trick

Hope this helps,

Sybrand Bakker
Senior IS Analyst
Bentley Systems Europe

#include <std_dclaimer.h> Received on Thu Oct 19 1995 - 00:00:00 CET