Re: Table keeps growing inspite of purging

I have Oracle 7.3.2.

Julio wrote in message <347CEB67.7C2_at_si.unirioja.es>... Sasha Ostojic wrote:
>
> What if I set PCTUSED 99 and PCTFREE 0? Would that ensure maximum re-use
 of
> freed space? I tried this, and it did not seem to degrade performance
 much.
>
> .sasha

Wich is your ORACLE version? In 7.1.6 Oracle doesn't reuse space. I remember now the number of problems with the Installation of Designer 2K (we have to install and uninstall it a lot of times) and the space was not freed..

--
Julio Negueruela
Telf: 941-299177    Fax: 941- 299244
Servicio Informático
Universidad de La Rioja - Spain
mailto:julio.negueruela_at_si.unirioja.es