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 -> reclaiming table size

reclaiming table size

From: <eoin7_at_my-deja.com>
Date: Mon, 14 Jun 1999 21:13:22 GMT
Message-ID: <7k3r99$3sa$1@nnrp1.deja.com> 





Oracle 8:



I have some tables that store data temporarily, with many inserts and
deletes occuring daily. The tables can never be empty, so TRUNCATE is
not an option.



What is the best way to manage the table size?
Will these tables continue to use more and more storage in the
tablespace because of not being able to TRUNCATE REUSE STORAGE?



Thanks.




Sent via Deja.com http://www.deja.com/



Share what you know. Learn what you don't.
Received on Mon Jun 14 1999 - 16:13:22 CDT












Original text of this message













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