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

Home -> Community -> Usenet -> c.d.o.misc -> 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