RE: LMTs
Date: Mon, 10 Mar 2008 10:36:12 -0400
Message-ID: <F4C27E77F7A33E4CA98C19A9DC6722A202B6F37F@EXCHANGE.corp.perceptron.com>
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-lReceived on Mon Mar 10 2008 - 09:36:12 CDT