Re: MINIMUM EXTENT option

From: Jurij Modic <jmodic_at_src.si>
Date: Fri, 16 Oct 1998 07:05:42 GMT
Message-ID: <3626ee90.1959000@news.siol.net>

On Thu, 15 Oct 1998 22:38:51 -0500, John Durst <jdurst_at_sky.net> wrote:

>MINEXTENTS and MINIMUM EXTENT are two different things. MINIMUM EXTENT
>controls free space fragmentation in an Oracle8 database because in addition to
>specifying the size of the smallest extent allocated in the tablespace, it also
>forces each extent in the tablespace to be a multiple of that minimum value.
>That way if you drop any segment in the tablespace, the chances are you will be
>able to reclaim all of the released space.

I stand corrected, you are absolutely right. I should read the posts more carefully before replying.

Thanks for clarification.

Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Oct 16 1998 - 02:05:42 CDT