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

Re: Truncate before drop. Any real improvement?

From: Franky R. <trek1s_at_gmail.com>
Date: 14 Sep 2006 04:30:47 -0700
Message-ID: <1158233447.564414.80760@p79g2000cwp.googlegroups.com>


sybrandb wrote:
>
> If you are going to DROP the table, TRUNCATE doesn't make sense at all,
> as in both cases records are not deleted, and no redo is generated.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Thanks for clearing it up.

Regards Received on Thu Sep 14 2006 - 06:30:47 CDT

Original text of this message

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