Re: drop table takes forever

From: Trifon Anguelov <trifona_at_pacbell.net>
Date: Sat, 26 Jan 2002 02:38:19 GMT
Message-ID: <vEo48.2217$JY.1547636869@newssvr14.news.prodigy.com>

Miker,

If your extents size is small and you created with unlimited extents, then it is normal for Oracle to take a while since clean up all extent info in the data dictionary first.

Make sure you disable all indexes, triggers and constraints first before doing TRUNCATE.

Here is a good way of deleting large volume of records, if you needed on day:
http://www.oracle.com/oramag/webcolumns/2000/index.html?DeletingData_Hart.ht ml

Hope that helps,

Trifon Anguelov
Senior Oracle DBA

http://www.dbaclick.com

"miker" <mdent12_at_none.com> wrote in message news:p0t35ucv12snrajjelbaj0oa0qg3dnu58d_at_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 - 20:38:19 CST