Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: release after delete
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.
-- NoelReceived on Tue Dec 02 2003 - 07:56:38 CST