RE: LMTs
- From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
- To: <joe_dba@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 10 Mar 2008 10:36:12 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joe Smith
Sent: Monday, March 10, 2008 10:30 AM
To: oracle-l@xxxxxxxxxxxxx
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>
Other related posts:
