Re: UPDATING many LOBS what happens to the freed space.

From: Lionel Mandrake <nobody_at_nospam.nowhere.nohow>
Date: Wed, 14 Nov 2001 02:46:38 GMT
Message-ID: <iWkI7.143590$My2.83642478@news1.mntp1.il.home.com>

"Brian Tkatch" <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK> wrote in message news:3bf16d0a.593875296_at_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

Man, it must be a bummer not having a test system... :)

In the meantime, have a look at this question from the world's greatest Oracle Q & A site:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:167102897 7790

I believe you can extrapolate what you need to know from that...

-LM Received on Tue Nov 13 2001 - 20:46:38 CST