Re: reclaiming table size

From: karsten reincke <kreincke_at_cl-ki.uni-osnabrueck.de>
Date: Tue, 15 Jun 1999 14:30:19 +0200
Message-ID: <3766475B.24AD8A51@cl-ki.uni-osnabrueck.de>

eoin7_at_my-deja.com wrote:
>
> 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.
>
> (a) What is the best way to manage the table size?
> (b) Will these tables continue to use more and more storage in the
> tablespace because of not being able to TRUNCATE REUSE STORAGE?

hello:

answer to (b)

definitely not: the worst case that the table will stay at the size-level of the largest last table. but note: setting the pctfree and pctused value won't change this fact.

answer to (a) if you are sure that your temporary data are stored in escpecial tables not containing more than these temporary data and therefore definitely being temporary data why then not using a drop-table at each day? should be organizable. shouldn't it? --

       salut d'Allemagne kr

---

les chats cont les vrais hédonistes
et devraient être donc notre idéal.

---

 karsten reincke [ 0541/9696223 ]
 kreincke_at_cl-ki.uni-osnabrueck.de Received on Tue Jun 15 1999 - 07:30:19 CDT