Re: release after delete

From: Wolfgang Breitling <John.Doe_at_aol.com>
Date: Wed, 03 Dec 2003 02:07:54 GMT
Message-ID: <Xns9445C29896C5Dbreitliwcentrexcccom@198.161.157.145>

Daniel Morgan <damorgan_at_x.washington.edu> wrote in news:1070328583.867150 @yasure:

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

>
> CREATE TABLE temp_table AS
> SELECT *
> FROM original_table
> NOLOGGING;
>
> TRUNCATE TABLE orginal_table;
>
> INSERT INTO original_table
> SELECT * from temp_table;
>
> DROP temp_table;
>

Why not simply "alter table ... move" - unless the table still uses a long - followed by index rebuilds. This would be a legitimate and necessary use of alter index rebuild. Received on Tue Dec 02 2003 - 20:07:54 CST