Re: Defining rollback segment for a transaction

Another point: If you are working with sqlplus ensure that autocommit is set to OFF, otherwise after each statement sqlplus will insert a commit.
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