Hi, the trick is to use package dbms_space_admin (Cf Oracle Doc) to convert from DMT to LMT. With this method, you obtain a "USER" allocation type as seen in dba_tablespaces view that allow you to use maxextents clause.
N.B. to ease the conversion, it's better to have DMT tablespaces already using "minimum_extent" clause Hope this helps At 13:33 06/01/2003 -0800, you wrote: >Hi: > >Oracle 8173 on Sun Solaris 2.8. > >I am in the process of converting rollback segments from DMT to LMT (to see >how much performance we can get, if any). The tablespace size is 8G and I >used to create rbs like: > >create rollback segment RBS00X storage(initial 2048K next 2048K minextents >20 maxextents 800) tablespace rbs; > >I set maxextents to avoid "run away transaction". But now with rbs in LMT, >there is no way to set maxextents, how can we avoid "run away transaction" >in this situation? > >Thanks. > >Guang Mei > > >_________________________________________________________________ >Add photos to your e-mail with MSN 8. Get 2 months FREE*. >http://join.msn.com/?page=features/featuredemail > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Guang Mei > INET: [EMAIL PROTECTED] > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com >San Diego, California -- Mailing list and web hosting services >--------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > > > Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
