Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> UPDATING many LOBS what happens to the freed space.

UPDATING many LOBS what happens to the freed space.

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Tue, 13 Nov 2001 19:11:38 GMT
Message-ID: <3bf16d0a.593875296@news.alt.net> 





We have a table with a LOB column in its own tablespace. The LOBs need
to be UPDATEd with newer data. The newer data takes up about half the
amount of the larger data.



LOB





Old   = 15-30k


New = 7.5-15k




When the UPDATE is done, will it reuse the same space? The intention
is to do it in batches. Do a few then COMMIT. Repeat.



I believe I read in the documentation that they are UPDATEd in the
same block, if possible.



Further, when it is all done, would I need tro COALESCE the
tablespace?



Brian
Received on Tue Nov 13 2001 - 13:11:38 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US