RE: Urgent! Taking a Long Time to drop Tables

Larry,

Clearing extents can take time. However:

I'm pretty sure that in 1998 (I think) we ran into this exactly, and there was a bug that drop tables takes too long. It was because  of a missing index on one of the sys data dictionary tables. The fix was to create the index, and then it worked. Lemme check Metalink quickly...

... Ok, I'm back. I didn't find it on Metalink, but I'm fairly certain I had found it online when it happened in 98 (and I worked for Oracle). If it continues to bother you, call support.

Sorry I couldn't be of more help.

Yosi

> -----Original Message-----
> From: Larry Taylor [mailto:ltaylor_at_iq.com]
> Sent: Tuesday, December 19, 2000 2:12 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Urgent! Taking a Long Time to drop Tables
>
>
> Hi all,
>
> Does anyone out there have any suggestions as to
> why it would take 12 minutes to drop tables.
> Where should I look first?
>
> Thanks
> Larry
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Larry Taylor
> INET: ltaylor_at_iq.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Dec 19 2000 - 14:07:38 CST