LMTs
From: Joe Smith <joe_dba_at_hotmail.com>
Date: Mon, 10 Mar 2008 09:30:07 -0500
Message-ID: <BLU108-W23AAE9CFFEE410A0B8F00C970E0@phx.gbl>
Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan
Date: Mon, 10 Mar 2008 09:30:07 -0500
Message-ID: <BLU108-W23AAE9CFFEE410A0B8F00C970E0@phx.gbl>
CREATE TABLESPACE dataDATAFILE '/FS/data_s01.dbf' size 2000m autoextend on next 1m maxsize 12000m, '/FS/data_s02.dbf' size 2000m autoextend on next 1m maxsize 12000mEXTENT MANAGEMENT LOCAL UNIFORM SIZE 1MSEGMENT 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. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 10 2008 - 09:30:07 CDT