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

This message: [ Message body ]
Next message: Hans: "Re: Urgent Help Needed!"
Previous message: emel_yep_at_yahoo.com: "Oracle Forms Runtime Process in own host?"
In reply to: sybrandb: "Re: Truncate before drop. Any real improvement?"
Next in thread: Connor McDonald: "Re: Truncate before drop. Any real improvement?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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