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:


Greetings

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:
http://www.catb.org/~esr/faqs/smart-questions.html

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

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

References:

TRUNCATE Before Drop ???
From: BN

Other related posts:

Browse oracle-l