Re: space recover for ORACLE 7

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 3 Sep 2001 21:55:48 +0200
Message-ID: <tp7or53l9h1eba@news.demon.nl>

"Antonio Martinez" <anmartinez_at_itevelesa.com> wrote in message news:3b93bbec$1_4_at_news.landsraad.net...
> i dont know how oracle 7 do with delete records, what happend with space?
> can i recover this??
>
> thanks for all.
>
>

>

for tables : when the percentage of the block used falls below the pct_used defined on table level in the dictionary, the block will be placed on the free list, which means the block is a candidate for inserts again. Index blocks are not reused.

Such broad questions are best adressed by reading the Oracle Concepts Manual instead of posting to this group.

Oracle 7 has been desupported

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Mon Sep 03 2001 - 14:55:48 CDT