Re: Help: free space within a BLOB table
From: D Parent <dparent6_at_home.com>
Date: 2000/07/03
Message-ID: <Gz985.44447$7I1.680252_at_news1.rdc2.on.home.com>#1/1
Date: 2000/07/03
Message-ID: <Gz985.44447$7I1.680252_at_news1.rdc2.on.home.com>#1/1
You can use the DBMS_LOB package and use the GETLENGTH parameter to find out
the size of it. I am not sure if this is what you are looking for hope it
helps
susana73_at_hotmail.com wrote in message <8jr0id$5t6$1_at_nnrp1.deja.com>...
>Hi there,
>
>I have a 50GB table which I consistently delete and insert data. I
>would like to check the free space(unused blocks/bytes) within this
>table frequently. However, the blocks, empty_blocks column in
>dba_tables only shows the statistics on table segment, NOT the BLOB
>segment of the table. Anyone know how to get the space statistis on
>BLOB segment?
>
>Thanks in advance!
>
>Susan
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Mon Jul 03 2000 - 00:00:00 CEST