Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UPDATING many LOBS what happens to the freed space.
On Wed, 14 Nov 2001 02:46:38 GMT, "Lionel Mandrake"
<nobody_at_nospam.nowhere.nohow> wrote:
>
>"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
>
>
set serveroutput on
BEGIN
For Gratitude IN 1..1000 LOOP
DBMS_OUTPUT.PUT_LINE('Thank you.');
LOOP
END;
/
Brian Received on Wed Nov 14 2001 - 06:45:12 CST