Re: ROLLBACK SEGMENT?

Hi Raj,

Interesting that you first agree with Jeremy and then argue with him.  It is precisely because
export does not generate rollback that the "gymnastics" of taking all of the other rbs's offline
will not help anything.  It might make you feel better, however :-).

John

Rajesh.Rao_at_chase.com wrote:           

      Export doesn't generate any rollback, right, so what is it supposed toaccomplish by doing this incantation?
      
      
      
      
        Sorry to press the point, but could you elaborate on how that "COULD"possibly make any difference for 'snapshot too old'?
        
        For the same reason, any other transaction could end up with a snapshot tooold error. Export does not generate any rollback, but there could be usersperforming DML operations on the table  that is being exported, and theexport needs to be redirected to read from the rollback segments. Thelikelihood of the error being thrown up especially if one uses theconsistent parameter could be very high, if you dont have a large enoughrollback segment without an optimal clause.RajJeremiah Wilton <jwilton_at_speakeasy.net>@fatcity.com on 01/23/2002 11:20:40AMPlease respond to ORACLE-L_at_fatcity.comSent by:  root_at_fatcity.comTo:   Multiple recipien
ts of list ORACLE-L <ORACLE-L_at_fatcity.com>cc:On Tue, 22 Jan 2002, Rajesh.Rao_at_chase.com wrote:
        
          Hmmmm ... "COULD" help in avoiding snapshot too old errors.
          
          Sorry to press the point, but could you elaborate on how that "COULD"possibly make any difference for 'snapshot too old'?--Jeremiah Wiltonhttp://www.speakeasy.net/~jwilton
          
            Jeremiah Wilton <jwilton_at_speakeasy.net> wrote:So what does it accomplish to "assign export [to] a particularrollback segment?"Export doesn't generate any rollback, right, so what is it supposed toaccomplish by doing this incantation?On Tue, 22 Jan 2002, Jason Rowski wrote:
            
              ... you can use the following trick to assign export aparticular rollback segment -1) Create a rollback segment tablespace with one largesegment and bring it online before export.2) Offline all existing rollback segments.3) Export the database4) Offline the large tablespace created earlier.5) Bring back the orginals rollback segments online.--- Seema Singh <oracledbam_at_hotmail.com> wrote:
              
                Can I use one rollback segment at time of export?Isyes,thenSET TRANSACTION USE ROLLBACK SEGMENTrollbacksegmentname;
                
                
                
                --Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Jeremiah Wilton  INET: jwilton@speakeasy.netFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).