Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Losing space when deleting

Re: Losing space when deleting

From: Blues <gotblues_at_multimania.com>
Date: Sat, 25 Sep 1999 00:47:53 +0200
Message-ID: <7sgv2e$c88$1@front5m.grolier.fr> 





Hi Mary,



Use "truncate table" and no "delete from table" command because space will
be free.


Be carefull : behaviour is not the same : no rollback, no trigger fired no
delete cascade, etc.



Regards,



yann



Received on Fri Sep 24 1999 - 17:47:53 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US