Help: free space within a BLOB table
From: <susana73_at_hotmail.com>
Date: 2000/07/03
Message-ID: <8jr0id$5t6$1_at_nnrp1.deja.com>#1/1
Date: 2000/07/03
Message-ID: <8jr0id$5t6$1_at_nnrp1.deja.com>#1/1
[Quoted] 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