Re: release after delete

On Mon, 1 Dec 2003 21:48:16 +0100, "zeb" <thierry.constant1.nospam_at_free.fr> wrote:

>Hi
>
>Is it possible to release the space after a big delete ?
>other than export/import
>Thanks in advance
>( oracle 8.1.7, HP-UX 11.0)
>

There are various strategies:
- issue alter table <blah> deallocate unused manually after your delete. The deallocated extent must be completely empty - modify pctincrease and pctused so a block is being put on the free list sooner
- other than that: copy the remaining rows, truncate the table, copy the rows back in.

With Automatic Segment Storage Management in Oracle 9i this issue should become history

--
Sybrand Bakker, Senior Oracle DBA