RE: LMTs

Just remove "next 1m", as in:  

CREATE TABLESPACE data
DATAFILE '/FS/data_s01.dbf' size 2000m autoextend on maxsize 12000m,

'/FS/data_s02.dbf' size 2000m autoextend on maxsize 12000m
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO; Igor

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joe Smith Sent: Monday, March 10, 2008 10:30 AM
To: oracle-l_at_freelists.org
Subject: LMTs

CREATE TABLESPACE data
DATAFILE '/FS/data_s01.dbf' size 2000m autoextend on next 1m maxsize 12000m,

'/FS/data_s02.dbf' size 2000m autoextend on next 1m
maxsize 12000m
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
SEGMENT SPACE MANAGEMENT AUTO; How do you control the size of LMTs.  

If I remove the "autoextend on next 1m" I can't use the "maxsize" keyword.  

How do I restrict the size of the datafiles for LMTs      

Climb to the top of the charts! Play the word scramble challenge with star power. Play now!
<http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_ jan>

--
http://www.freelists.org/webpage/oracle-l