Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Calculating HWM(Table)

Calculating HWM(Table)

From: beersa <sabeer.oracle_at_gmail.com>
Date: 3 Sep 2006 00:01:47 -0700
Message-ID: <1157266907.251296.270480@m79g2000cwm.googlegroups.com> 





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


After moving the table to different tablespace, the size is reduced to
1M, why?


How can measure the size of a table without calculating its high water
marks spaces?



Thanks&Cheers



BEERSA

Received on Sun Sep 03 2006 - 02:01:47 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US