From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.server Subject: Re: space management for lob data type Date: Tue, 10 Oct 2000 18:13:31 +0100 Message-ID: <971198769.26641.0.nnrp-07.9e984b29@news.demon.co.uk> References: <8ribdf$c5n$1@nnrp1.deja.com> <970921812.2305.1.nnrp-09.9e984b29@news.demon.co.uk> <8rtecn$mpj$1@nnrp1.deja.com> NNTP-Posting-Host: jlcomp.demon.co.uk X-NNTP-Posting-Host: jlcomp.demon.co.uk:158.152.75.41 X-Trace: news.demon.co.uk 971198769 nnrp-07:26641 NO-IDENT jlcomp.demon.co.uk:158.152.75.41 X-Complaints-To: abuse@demon.net X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Lines: 64 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@yahoo.com wrote in message <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@news.demon.co.uk>, > "Jonathan Lewis" 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@yahoo.com wrote in message <8ribdf$c5n$1@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.