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

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

TRUNCATE Before Drop ???

From: BN <bnsarma_at_gmail.com>
Date: Thu, 26 Apr 2007 10:24:02 -0400
Message-ID: <61292a9d0704260724s4a6c4bd4yf6c388e8fdda9966@mail.gmail.com> 





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?


-- 
Regards & Thanks
BN

--
http://www.freelists.org/webpage/oracle-l


Received on Thu Apr 26 2007 - 09:24:02 CDT












Original text of this message













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