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 -> Re: drop table takes forever

Re: drop table takes forever

From: miker <mdent12_at_none.com>
Date: Sat, 26 Jan 2002 04:35:45 GMT
Message-ID: <ldc45u0tq2d8ik8h9bpfgs6p4btot5n7fs@4ax.com>


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

Original text of this message

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