Re: release after delete

From: Yong Huang <yong321_at_yahoo.com>
Date: 3 Dec 2003 17:51:11 -0800
Message-ID: <b3cb12d6.0312031751.56c66846@posting.google.com>

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

How about ALTER TABLE yourtablename MOVE? It's easier than export / import. Make sure you take care of indexes and lob segments for the table.

Yong Huang Received on Wed Dec 03 2003 - 19:51:11 CST