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

Home -> Community -> Mailing Lists -> Oracle-L -> How to find out free space below High Water Mark in table

How to find out free space below High Water Mark in table

From: Daiminger, Helmut <Helmut.Daiminger_at_KirchGruppe.de>
Date: Mon, 21 Jan 2002 08:04:38 -0800
Message-ID: <F001.003F5E1D.20020121073545@fatcity.com> 









Hi!




I deleted several thousand rows from a table, but it looks like the table is still taking up the same amount of space in the tablespace. Which it indeed does, because delete does not reset the HWM.



Does anybody out there have a script that gives me the free space in a table below the high water mark?




This is 8.1.7 on Sun Solaris.




Thanks,


Helmut




Received on Mon Jan 21 2002 - 10:04:38 CST












Original text of this message













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