Re: TRUNCATE Before Drop ???

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: bnsarma@xxxxxxxxx
  • Date: Thu, 26 Apr 2007 09:27:21 -0700

On 4/26/07, BN <bnsarma@xxxxxxxxx> wrote:


This is dropping a  Big Table around 150 GB in different Oracle Versions
(8i,9i,10g) with LMTS and Dictionary TBS

Can a TRUNCATE Table  Before drop help in system resources and drop time?

This is pretty vague.

Three versions of database, both with and without LMTS.

Perhaps you should ask a specific question.

There are some good guidelines for doing so at:

Better yet, devise some tests and inform us of your results.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: