Re: LMTs

• Joe Smith <joe_dba_at_hotmail.com> 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

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