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 -> Compact a Tablespace?

Compact a Tablespace?

From: Adrian Harrison <adrianh_at_globalnet.co.uk>
Date: Mon, 23 Aug 1999 09:38:33 GMT
Message-ID: <37c11549.81624820@news.globalnet.co.uk> 





Using Oracle 7.3.4



I have a tablespace (size = 30 meg), that I've just deleted probably 90% of the contents. 



Using the Navigator Tool that comes with Personnel Oracle the "Used Space" & "Free Space" hasn't
changed at all for this tablespace.



All the deletions were definetely committed so what I'm wondering is if I'm supposed to do some sort
of "compact" to free this space up!



Any ideas?



Thanks



Adrian Harrison
Received on Mon Aug 23 1999 - 04:38:33 CDT












Original text of this message













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