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
Other related posts:
