Re: TRUNCATE Before Drop ???

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

Other related posts: