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

Home -> Community -> Usenet -> c.d.o.server -> drop table takes forever

drop table takes forever

From: miker <mdent12_at_none.com>
Date: Sat, 26 Jan 2002 00:12:28 GMT
Message-ID: <p0t35ucv12snrajjelbaj0oa0qg3dnu58d@4ax.com> 





I have a table with 12 million records.  If I try DROP TABLE it takes
forever.  I tried TRUNCATE TABLE and that takes a long time too.  Is
there any way to delete the entire table quickly?
Received on Fri Jan 25 2002 - 18:12:28 CST












Original text of this message













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