re: atual data size...

From: Ati Rosselet <ati.rosselet_at_clarmont.hu>
Date: Wed, 9 Jan 2002 12:21:20 +0100
Message-ID: <a1h8iq$aks$1@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

Privileged/confidential information may be contained in this
message. This communication is confidential and intended
solely for the addressee(s). Unauthorized distribution,
modification or disclosure of the contents may be unlawful.
If you receive this in error, please notify the sender and
delete it from your system. If you are not the addressee
indicated in this message (or responsible for delivery of the
message to such person), you may not copy or deliver this
message to anyone. Please advise immediately if you or your
employer does not consent to Internet e-mail for messages of
this kind. Opinions, conclusions and other information in
this message that do not relate to the official business of
CLARMONT Systems Ltd shall be understood as neither given nor
endorsed by it. Views expressed herein do not necessarily
reflect those of CLARMONT Systems Ltd

Received on Wed Jan 09 2002 - 05:21:20 CST