Re: LMTs
- From: Nigel Thomas <nigel_cl_thomas@xxxxxxxxx>
- To: joe_dba@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 10 Mar 2008 07:51:02 -0700 (PDT)
--- Joe Smith <joe_dba@xxxxxxxxxxx> wrote:
> 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
MAXSIZE only comes with AUTOEXTEND ON. If you are going to be extending
manually, Oracle presumes you know what you are doing when you do it.
See the railroad diagrams in
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/clauses004.htm#i998826
The textual description is:
AUTOEXTEND
{ OFF
| ON [ NEXT size_clause ]
[ maxsize_clause ]
}
Regards Nigel
--
//www.freelists.org/webpage/oracle-l
Other related posts:
