Re: avoiding tablespace fragmentation

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Mon, 7 Jun 2004 05:55:46 +1000
Message-ID: <40c376ae$0$8985$afc38c87@news.optusnet.com.au>

"anacedent" <anacedent_at_hotmail.com> wrote in message news:YZEwc.50386$oi5.24062_at_fed1read07...
> yls177 wrote:
> > is it true that as long as i dont drop/truncate tables, then there
> > will be no tablespace fragmentation provided that i set my storage
> > parameters at tablespace level as the below
> >
> > 1) initial extent=next extent
> > 2) pctincrease 0
> >
> > thanks
> define "tablespace fragmentation", please

Tablespace fragmentation is what happens when (A) you drop or truncate or move objects, thus freeing space; and (B) where the objects so moved, truncated or dropped had differently-sized extents.

I think that's what he was talking about, anyway.

Regards
HJR Received on Sun Jun 06 2004 - 14:55:46 CDT