Re: space management for lob data type

From: <tedchyn_at_yahoo.com>
Date: Mon, 09 Oct 2000 21:47:05 GMT
Message-ID: <8rtecn$mpj$1@nnrp1.deja.com>

jonathan,
after deleting a record,the space is available for use if pctversion is set to zero ?

thnx ted
In article <970921812.2305.1.nnrp-09.9e984b29_at_news.demon.co.uk>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> LOBs are stored in CHUNKs, the CHUNKSIZE can be
> set only when you create the table holding the LOB.
>
> All LOB blocks are 100% full, and pctused/pctfree
> do not apply. Instead there is a PCTVERSION
> defined at create time that specifies the percentage
> of the currently used volume of the lob segment
> that may be used for retaining out of date copies
> of LOB CHUNKS.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> tedchyn_at_yahoo.com wrote in message <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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 09 2000 - 16:47:05 CDT