From JTESTA@longaberger.com Thu, 04 Oct 2001 09:57:31 -0700 From: "JOE TESTA" Date: Thu, 04 Oct 2001 09:57:31 -0700 Subject: Re: Dropping table is not completing Message-ID: MIME-Version: 1.0 Content-Type: text/plain Richard, is it just sitting there?  could it have a large numebr of extents that oracle is deleting entries from uet$ and inserting back to fet$?   joe >>> RICHARD.T.CALE@saic.com 10/04/01 01:55PM >>>Hi All,I am trying to drop a table. It is not locked and has very few records init.  I am trying to drop it but it will not.What can I check to find out why it will not drop?ThanksRick-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Cale, Rick T (Richard)  INET: RICHARD.T.CALE@saic.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).