Oh.. and the table has BLOB fields in it...just to make life harder.. any
ideas??
Tnx.
"Ati Rosselet" <ati.rosselet_at_clarmont.hu> wrote in message
news:a1h8iq$aks$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..)
>
Received on Wed Jan 09 2002 - 05:38:55 CST
