Re: space management for lob data type

I haven't done this specific test, but I would expect the answer to be yes. However, to allow for rollback of the LOB, you can't reuse the space made free by the LOB until after you have committed (a bit like index entries in b-trees), so for absolutely minimal space loss, you will probably have to do:

    delete
    commit
    insert

rather than

    delete
    insert
    commit;

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

tedchyn_at_yahoo.com wrote in message <8rtecn$mpj$1_at_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.