Re: release after delete

"zeb" <thierry.constant1.nospam_at_free.fr> wrote in message news:3fcba89d$0$27036$626a54ce_at_news.free.fr

> 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)

Hi,
you can use:
alter table <tablename> move;
This should be followed by the index rebuild. As the table itself is rebuild,
the asociated indexes gets invalid.
Thanks,
Saikat Chakraborty
http://saikatchak.tripod.com

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG