Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: TRUNCATE Before Drop ???

Re: TRUNCATE Before Drop ???

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 26 Apr 2007 09:27:21 -0700
Message-ID: <bf46380704260927g61c8022dt7510fa40a103722f@mail.gmail.com>


On 4/26/07, BN <bnsarma_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 26 2007 - 11:27:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US