Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Change Rollback Segment
I have a sql-script with many statements. It's working with
autocommit. The Rollback Segment is too small. There are other bigger
RBS on the DB.
How can I change the RBS on which the script is working? I do not want to do this by "set transaction set rollback segment", because I would have to name the RBS in too many places in the script.
I'd rather tell the session, with which RBS it should work. Or maybe there is a way to define the default RBS of the user?
TIA
Erich
-- Erich-Scholz_at_t-online.deReceived on Fri Jun 21 2002 - 05:58:50 CDT