Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question about Rollback Segments
> After the first COMMIT, will my program still use the rollback segment I told
> it to use, or will it randomly select another?? Remember, there are multiple
> commits within the same transaction.
You want to code as follows:
commit;
set transaction use rollback segment <segment name>
Daniel A. Morgan Received on Mon Sep 14 1998 - 23:47:44 CDT