Re: Freeing of chained row blocks

From: <vijaylamba_at_my-deja.com>
Date: Sat, 04 Dec 1999 10:52:09 GMT
Message-ID: <82arop$nma$1@nnrp1.deja.com>

Hi,
The blocks are not freed automatically. You will need to take an export of that object and import it back. That will also defrag your extents. Hope this helps.
Bye
Vijay

In article <38481419.9136FA12_at_arlut.utexas.edu>, Chip Gentry <cgentry_at_arlut.utexas.edu> wrote:
> Are blocks associated with a chained row automatically freed and
> available for reuse if the row decreases in size such that chaining is
> no longer required?
>
> Is there a difference between version 7.0.16 and version 7.3.3 in how
> this is handled?
>
> Thanks,
> --
> ------------------------------------------------------------
> M. L. "Chip" Gentry
> ---------------------------------------------------------------
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Dec 04 1999 - 04:52:09 CST