Re: space recover for ORACLE 7

Deletes never have and never will release space within the database -the only thing that frees space is any command that results in extents being released. "Truncate" will do that, as will "Drop".

If you've deleted all rows in a table, then try a 'truncate table X' (and incidentally, for future reference, a truncate is a much quicker way of getting rid of all records than a 'delete from Y' command).

If there are still some rows left that you'd like to keep, perform an export with compress=N, then drop or truncate the table(s) manually, and follow that up with an import (otherwise known as a tablespace reorg). You should then see much more free space available within the tablespace.

The basic issue is that inserts can result in extent allocation, but deletes never result in extent de-allocation.

Regards
HJR "Antonio Martinez" <anmartinez_at_itevelesa.com> wrote in message news:3b93bb3d$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.
>
>
Received on Mon Sep 03 2001 - 15:23:16 CDT