| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Dropping table is not completing
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 accessing
database currently.
Thanks
Rick
<FONT
face=Tahoma>-----Original Message-----From: JOE TESTA
[mailto:JTESTA_at_longaberger.com]Sent: Thursday, October 04, 2001
2:16 PMTo: Multiple recipients of list ORACLE-LSubject:
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
>>> RICHARD.T.CALE_at_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: <A
href="http://www.orafaq.com">http://www.orafaq.com-- Author: Cale,
Rick T (Richard) INET: RICHARD.T.CALE_at_saic.comFat City
Network Services -- (858) 538-5051 FAX: (858)
538-5051San Diego, California --
Public Internet access / Mailing
Lists--------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_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). Received on Thu Oct 04 2001 - 12:44:43 CDT
 |
 |