Re: How to set rollback segment for tablespace

From: Ed Steinman <esteinma_at_aal.itd.umich.edu>
Date: 16 Feb 1994 17:35:06 GMT
Message-ID: <2jtlgaINNgo6_at_srvr1.engin.umich.edu>

In article <TIM.94Feb9150031_at_sun1.claremont.com> Tim Maggio, tim_at_sun1.claremont.com writes:
>How do I set the rollback segment for a tablespace (or user)?

You can create one big rollback segment. Say you call it rb_big. When you need to use it you can force its use by entering:   

   commit;
   set transaction use rollback segment rb_big;

Right after this do your load or whatever you want to do--rb_big will be used for the transaction. Be sure to do a commit before the "set transaction to ..."

-----------------------------------------------------------------
Ed Steinman                                           What the Zen
Buddhist said to the
Computing Unit, School of Dentistry      hot dog vendor:
University of Michigan
Ann Arbor, MI 48109-1078                    "Make me one with

everything."
313-764-9850
FAX 313-747-4024
Internet: ed.steinman_at_um.cc.umich.edu Usenet: esteinma_at_aal.itd.umich.edu Received on Wed Feb 16 1994 - 18:35:06 CET