Rick,
Open up another sqlplus session and check the activivity of sys.uet$ and
sys.fet$ as Joe suggested. If you had a large number of extents in this
table you could be doing a lot of deletes and inserts into these
tables. (UET$ = Used Extent Table, FET$ = Free Extent Table). To
check this do the following:
select count(u.ts#) UET_COUNT, count(f.ts#) FET_COUNT
from sys.uet$ u, sys.fet$ f, v$tablespace t
where u.ts# = t.ts#
and f.ts# = t.ts#
and t.name = 'USERS'; /*or whatever tablespace name your table
is in*/
UET_COUNT FET_COUNT
---------- ----------
2158824 2158824
1 row selected.
Run this a few times and see how much the numbers are changing. This
will let you know where you are with your truncate.
Rodd Holman
"Cale, Rick T (Richard)" wrote:
> Joe,It is just sitting there. I am trying to truncate then drop but
> truncating is just sitting there. There are no constraints on this
> table and I am the only one accessingdatabase currently. ThanksRick
>
> -----Original Message-----
> From: JOE TESTA [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 04, 2001 2:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Dropping table is not completing
>
> 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
>
> >>> [EMAIL PROTECTED] 10/04/01 01:55PM >>>
> Hi All,
>
> I am trying to drop a table. It is not locked and has very
> few records in
> it. I am trying to drop it but it will not.
> What can I check to find out why it will not drop?
>
> Thanks
> Rick
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cale, Rick T (Richard)
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rodd Holman
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
