Re: Defining rollback segment for a transaction

There are some important facts:
1. this setting is valid only for the current transaction 2. set transaction use... has to be the first statement of a transaction

   (i.e. immediately after an commit or rollback) 3. any DDL statement or any other statement that causes an implicit commit

   ends the transaction and the set transaction ... is no longer valid

HTH Michael

Tam Wing Fatt, Chiyuki Takahashi wrote:
>
> Hi,
>
> I am new to Oracle and have problem understanding how to force
> Oracle to make use of a particular rollback segment which I have prepared.
>
> 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 ....
>
> In this case, I have problem completing the transaction (deletion) because
> the rollback segment used was not the one I prepared and Oracle runs into
> "insufficient space for extending rollback segment" problem. ... checking
> the log I found that it wasn't using the rollback segment I specified. Why?
>
> I've tried not specifying the "spool" inbetween and the transaction ended
> successfully.
>
> I don't seem to read any thing about such a constraint in any of the Oracle
> document I have.
>
> Will any kind soul out there please enlighten this amatuer here.
>
> You can reach me directly at wftam_at_mbox4.singnet.com.sg
>
> Many thanks in advance.
> Joseph Tam
> PS: I don't seem to be able to find an Oracle FAQ around. Do you have
> a clue?
Received on Sun Feb 08 1998 - 00:00:00 CST