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 -> Truncate before drop. Any real improvement?

Truncate before drop. Any real improvement?

From: Franky R. <trek1s_at_gmail.com>
Date: 14 Sep 2006 02:33:57 -0700
Message-ID: <1158226437.233510.254840@b28g2000cwb.googlegroups.com>


Hello,

Due to testing with some really big tables (creating, deleting, altering and updating involved) sometimes it's needed to drop the full table and start again.
AFAIK, "truncate" is the best way to remove all rows in a table, besides, it does not generate undo information.

So, does it make any sense to truncate a big table before dropping it? Is there any improvement in deleting a table previously truncated?

Thanks in advance. Received on Thu Sep 14 2006 - 04:33:57 CDT

Original text of this message

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