How to find actual size of data in a table

From: Ati Rosselet <ati.rosselet_at_clarmont.hu>
Date: Wed, 9 Jan 2002 12:23:09 +0100
Message-ID: <a1h8m7$al5$1_at_proxy.interware.hu>


Does anyone know how to determine the actual szie of a table in oracle. Not the extent size, but the actual amount of that used by data. The logical table size is easy to get, but if I delete data from a table after an extent has been added, then I still get the max size as opposed to the actual size. I need this because I need to then copy that data to a remote database (long story), and I need to be sure that a) the table will fit in available space, and that b) space is not wasted (as would be if using the size value corresponding to that max size) Thanks (please respond to my email address as well as the newsgroup since I seem to be having intermittent trouble accesseing the newsgroups..)

Ati



Ati Rosselet
C L A R M O N T Information Systems Ltd.

 www.clarmont.hu email: ati.rosselet_at_clarmont.hu


Received on Wed Jan 09 2002 - 12:23:09 CET

Original text of this message