Re: TRUNCATE Before Drop ???

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: