Re: release after delete

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 02 Dec 2003 21:04:56 -0800
Message-ID: <1070427926.451975@yasure>

Wolfgang Breitling wrote:

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

Depends on size and the number of indexes that would become invalid and require a manual rebuild.

My point was to suggest an alternative to export/import. Not to be exhaustive. There are probably a half-dozen or more ways to solve the problem.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Tue Dec 02 2003 - 23:04:56 CST