Re: LMT and DMT

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 5 Feb 2003 08:49:19 -0000
Message-ID: <3e40d013$0$240$ed9e5944@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

Received on Wed Feb 05 2003 - 02:49:19 CST