Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Change Rollback Segment

Change Rollback Segment

From: Erich Scholz <Erich-Scholz_at_t-online.de>
Date: Fri, 21 Jun 2002 12:58:50 +0200
Message-ID: <qb16hu048kahg2c55ifue7s89al0fmq8q6@4ax.com>


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.de
Received on Fri Jun 21 2002 - 05:58:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US