"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3e40d013$0$240$ed9e5944_at_reading.news.pipex.net...
> "tingl" <one4all_at_all4one.not> wrote in message news:ogZ%9.8085>
>
> <snip>
> > 1. To completely eliminate fragmentation, you can also make all extents
> the
> > same size in DMT,
> > even though fragmentation is more of an issue in theory than in
> > practice.
>
> You can do this, but you can't enforce it. There is no way to stop me
doing
> create table ah_ha_stuffed_you(col1 varchar2(200)) storage(initial 64k
next
> 5m pctincrease 75 minextents 10); should I suffer a momentary aberation.
In
> a LMT the table will still get appropriately sized extents.
>
> Personally, where possible, I like practice to mirror theory.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
>
>
>
Just recreate the table. Small price to pay for a momentary aberation. :)
Received on Wed Feb 05 2003 - 20:50:49 CST
