Defining rollback segment for a transaction

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