Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: release after delete
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;
-- 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 Mon Dec 01 2003 - 19:29:14 CST