Re: Calculating HWM(Table)

On 3 Sep 2006 00:01:47 -0700, "beersa" <sabeer.oracle_at_gmail.com> wrote:

>Can anyone clarify me the following doubts?
>A table size is 2M. After deleting some rows(1M), the size is still 2M.
>Why?

Because 2M has been allocated. You would need to deallocate unused *segments* (not *blocks*) using the alter table deallocate unused statement
>After moving the table to different tablespace, the size is reduced to
>1M, why?

Because all rows are inserted again, and they are contiguous after the insert
>How can measure the size of a table without calculating its high water
>marks spaces?

You can't
>
>Thanks&Cheers
>
>BEERSA

--
Sybrand Bakker, Senior Oracle DBA