Re: Tablespace Fragmentation during a rebuild

From: Burt Peltier <burttemp1ReMoVeThIs_at_bellsouth.net>
Date: Fri, 12 Dec 2003 21:06:36 -0600
Message-ID: <gjvCb.1080$qq.225@bignews1.bellsouth.net>

Assuming you are using DMT (Dictionary Managed Tablespace) because you see fragmentation.

I thought most people were moving to LMT (Locally Managed Tablespace) since 8iR2.

Since you are on 8iR3, you should use LMT and then you wouldn't have to worry about that 1 problem - tablespace fragmentaton.

-- 
"Daniel Trickett" <Daniel.Trickett_at_oracle.com> wrote in message
news:N7pCb.375814$ao4.1255125_at_attbi_s51...


> no oracle bashing today... I do enough of that on my own..

> that login is old, from my short stint in cons...

>

> hit the send before I could add the version of 8.1.7.4...

>

> fyi.... it is may be the compress and the parallelism combination.

> removed parallelism and it used contiguous space.

>

>

Received on Fri Dec 12 2003 - 21:06:36 CST