Re: space management for lob data type

From: Yong Huang <yhuang_at_indigopool.com>
Date: Fri, 6 Oct 2000 16:51:24 -0500
Message-ID: <8rlhcu$9a4$1@localhost.localdomain>

I can't give a definitive answer. I studied LOB space management in the manual but didn't see anything special about space reuse. It did talk a little bit about allocation (storage in row, chunk, etc.) I assume it's the same as other datatype when LOB is deleted and space is reused.

Yong Huang
yhuang_at_indigopool.com

<tedchyn_at_yahoo.com> wrote in message news:8ribdf$c5n$1_at_nnrp1.deja.com...
> sir, Is the oracle manage the space of lob data type in the same
> manner as regular varchar2 datatype if the lob column store in a
> different tablespace - it will be reused for inserting when the block
> is below pctused .
>
> thnx ted chyn
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 06 2000 - 16:51:24 CDT