Re: Defining rollback segment for a transaction

"Tam Wing Fatt, Chiyuki Takahashi" <wftam_at_mbox4.singnet.com.sg> wrote:

<SNIP>

>I have tried inserting some activities between defining the specific
>rollback segment and the actual transaction ... and found that the
>transaction end up NOT using the specified rollback segment.
>
>Eg.
> set transaction ...... myRBS
> spool ...
> delete * from ....

<SNIP>

>I've tried not specifying the "spool" inbetween and the transaction ended
>successfully.

The set transaction must be the first / starting statement within a transaction. ...and its only good for the duration of that transaction. I normally run it as

commit /* Not really committing anything... Terminating any previous transaction */
set transaction ... RBS_Large;
delete * from ....
commit /* ends transaction */

if you really want to do the spool then
set the RBS_LARGE online and
set all other rollback segments offline Received on Sun Feb 08 1998 - 00:00:00 CST