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 -> Recovering space after delete

Recovering space after delete

From: Oscar Ssentoogo <impala_at_enterprise.net>
Date: 1997/09/05
Message-ID: <5uojbu$jml$1@news.enterprise.net>#1/1 







We have large Oracle database tables.


We delete large amounts of records regardly, but the used tablespace area
seems to remain constant and not decrease after these deletes.



Is there a way of recovering this space (i.e. can you compact the database
as in MS Access). 



Or must you drop a tablespace file, delete this and recreate it to recover
the disk space?
Received on Fri Sep 05 1997 - 00:00:00 CDT












Original text of this message













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