Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: drop table takes forever
On Sat, 26 Jan 2002 02:38:19 GMT, "Trifon Anguelov"
<trifona_at_pacbell.net> wrote:
>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.
Yep, that was it! 6gb datafile and a 10k extent size. About 200,000+ extents to cleanup! Received on Fri Jan 25 2002 - 22:35:45 CST