Noel wrote:
> Uzytkownik "Daniel Morgan" <damorgan_at_x.washington.edu> napisal w wiadomosci
> news:1070328583.867150_at_yasure...
>
>>>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;
>>
>
> Hello.
> Its nice solution but sometimes could't be done :-(.
> You cannot just truncate table while there are foreign references...
> There is possible to drop that table with 'CASCADE CONSTRAINTS'
> and rename temp into orginal, but all references will be disabled or set to
> null.
> --
> Noel
Look at the DBMS_REDEFINITION package. It has its weaknesses but it
might work for you.
--
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 - 11:20:42 CST
