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 -> help with space in tablespaces

help with space in tablespaces

From: blah <blah_at_blah.com>
Date: Wed, 22 Aug 2001 00:20:11 GMT
Message-ID: <9luttp$t2r2@inetbws1.citec.com.au> 





Hi All,



When a data tablespace is nealy full and then say 1million rows are deleted my 
query will not show the reduction in data it only shows the space left above 
the high water mark.



Is their a way to show how much space is actually available in the tablespace 
now that 1 million rows have been deleted?



Thanks,


Chris 
Received on Tue Aug 21 2001 - 19:20:11 CDT












Original text of this message













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