title: Truncate table in Oracle
body: <p>I need to truncate a table that has around 40 million records in it. i guess it is ok to REUSE STORAGE for the table since new data will be inserted after the truncate.
  I need to know </p>
  
  <ol>
  <li><p>approximately how much time the command 
  <code>TRUNCATE TABLE &lt;tablename&gt; REUSE STORAGE;</code> would take.</p></li>
  <li><p>Can this be done offline, so that the operations/ commands on the DB
  don't get affected?</p></li>
  </ol>