Re: LMTs

Simply do SIZE 2G AUTOEXTEND OFF;

Stefan

On Mon, Mar 10, 2008 at 3:30 PM, Joe Smith <joe_dba_at_hotmail.com> wrote:

> 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>
>

-- 
=========================

Stefan P Knecht
Senior Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com

OCP 9i/10g SCSA SCNA
=========================

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