Hi,
I believe the syntax is:
set transaction use rollback segment <segmentname>;
>
> The statement for assigning a rollback segment (ALTER SESSION, I think) is
> Oracle SQL. You can execute it with prepare()/execute() or do() just like
> any other non-SELECT statement.
>
> Be aware that COMMIT releases the segment so you need AutoCommit off.
>
Cheers,
Michael
---//---
I don't need to compromise my principles, because they don't have the
slightest bearing on what happens to me anyway.
---Calvin (Calvin & Hobbes).
A computer lets you make more mistakes faster than any invention in human
history - with the possible exceptions of handguns and tequila.
----Ratliffe, M.