Re: Maxextents unlimited on LMT ?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 5 Jul 2002 09:23:38 +1000
Message-ID: <AH4V8.27732$Hj3.85855@newsfeeds.bigpond.com>

Hi Linda,

A lot (like the difference in talent between David Bowie and my next door neighbour singing in the shower).

You're right regarding MAXSIZE. If you have autoextend on on the datafiles, it will grow to the size of MAXSIZE.

MAXEXTENTS is completely different. It controls the maximum number of extents an object (eg. table) living in the tablespace can grow to. In a Locally Managed Tablespace this is automatically set for all objects, regardless of any storage clause to unlimited. So any object can pretty well grow to any size within the tablespace and you can't control it otherwise. In my humble opinion, a bit a drawback and an unfortunate loss of admin control.

Hope it make sense.

Cheers

Richard
"Linda Lee" <goforticket_at_yahoo.com> wrote in message news:f901fb80.0207040927.4284a422_at_posting.google.com...
> What's the difference between MAXSIZE on datafile and maxextents
> storage clause?
> I used MAXSIZE when created LMT tablespace. I assumed that it will put
> some limits on the space growth, and if the datafile reaches the
> MAXSIZE I have to add more datafile to the tablespace or use 'alter
> ... resize;'. Am I right?
>
> Thanks a lot.
Received on Thu Jul 04 2002 - 18:23:38 CDT