| 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: Urgent! Taking a Long Time to drop Tables
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C069FB.CDD838C2
Content-Type: text/plain;
charset="iso-8859-1"
That's what's happening when you either drop or truncate a table. If you truncate and specify reuse storage, the deallocation will not happen.
-----Original Message-----
From: bunyamin karadeniz [mailto:bunyamink_at_havelsan.com.tr]
Sent: Tuesday, December 19, 2000 3:16 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Urgent! Taking a Long Time to drop Tables
Deallocating extents of a table ?? How can I do that ? Delete from xxx??
Hi Larry,
Does your table have a lot of extents? Deallocating the extents may cause a drop (or truncate) statement to crawl.
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849
"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."
-----Original Message-----
From: bunyamin karadeniz [ mailto:bunyamink_at_havelsan.com.tr
<mailto:bunyamink_at_havelsan.com.tr> ]
Sent: Tuesday, December 19, 2000 2:31 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Urgent! Taking a Long Time to drop Tables
I do not know the reason .But
Perhaps you can truncate them .
> 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
<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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> -- Author: bunyamin karadeniz INET: bunyamink_at_havelsan.com.tr 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). ------_=_NextPart_001_01C069FB.CDD838C2 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <TITLE>RE: Urgent! Taking a Long Time to drop Tables</TITLE> <META content="MSHTML 5.00.3103.1000" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#a6caf0> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=459413820-19122000>That's what's happening when you either drop or truncate a table. </SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=459413820-19122000>If you truncate and specify reuse storage, the deallocation will not happen. </SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=459413820-19122000></SPAN></FONT> </DIV> <BLOCKQUOTE style="MARGIN-RIGHT: 0px"> <DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> bunyamin karadeniz [mailto:bunyamink_at_havelsan.com.tr]<BR><B>Sent:</B> Tuesday, December 19, 2000 3:16 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Re: Urgent! Taking a Long Time to drop Tables<BR><BR></DIV></FONT> <DIV><FONT face=Arial size=2>Deallocating extents of a table ?? How can I do that ? Delete from xxx??</FONT></DIV> <DIV>**********************************************<BR>Bunyamin K. Karadeniz<BR>Information Technologies Dept.<BR>Database Group Tel :90-312-2873565/1681<BR>HAVELSAN Ankara / TURKEY<BR>**********************************************</DIV> <BLOCKQUOTE style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px"> <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV> <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> <A href="mailto:lkoivu_at_qode.com" title=lkoivu_at_qode.com>Koivu, Lisa</A> </DIV> <DIV style="FONT: 10pt arial"><B>To:</B> <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> </DIV> <DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, December 19, 2000 10:56 PM</DIV> <DIV style="FONT: 10pt arial"><B>Subject:</B> RE: Urgent! Taking a Long Time to drop Tables</DIV> <DIV><BR></DIV> <P><FONT size=2>Hi Larry, </FONT></P> <P><FONT size=2>Does your table have a lot of extents? Deallocating the extents may cause a drop (or truncate) statement to crawl. </FONT></P><BR> <P><FONT size=2>Lisa Rutland Koivu</FONT> <BR><FONT size=2>Oracle Database Administrator</FONT> <BR><FONT size=2>Qode.com</FONT> <BR><FONT size=2>4850 North State Road 7</FONT> <BR><FONT size=2>Suite G104</FONT> <BR><FONT size=2>Fort Lauderdale, FL 33319</FONT> </P> <P><FONT size=2>V: 954.484.3191, x174</FONT> <BR><FONT size=2>F: 954.484.2933 </FONT><BR><FONT size=2>C: 954.658.5849</FONT> <BR><FONT size=2><A href="http://www.qode.com" target=_blank>http://www.qode.com</A></FONT> </P> <P><FONT size=2>"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."</FONT></P><BR> <P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: bunyamin karadeniz [<A href="mailto:bunyamink_at_havelsan.com.tr">mailto:bunyamink_at_havelsan.com.tr</A>]</FONT> <BR><FONT size=2>Sent: Tuesday, December 19, 2000 2:31 PM</FONT> <BR><FONT size=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT size=2>Subject: Re: Urgent! Taking a Long Time to drop Tables</FONT> </P><BR> <P><FONT size=2>I do not know the reason .But</FONT> <BR><FONT size=2>Perhaps you can truncate them .</FONT> <BR><FONT size=2>**********************************************</FONT> <BR><FONT size=2>Bunyamin K. Karadeniz</FONT> <BR><FONT size=2>Information Technologies Dept.</FONT> <BR><FONT size=2>Database Group Tel :90-312-2873565/1681</FONT> <BR><FONT size=2>HAVELSAN Ankara / TURKEY</FONT> <BR><FONT size=2>**********************************************</FONT> <BR><FONT size=2>----- Original Message ----- </FONT><BR><FONT size=2>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com></FONT> <BR><FONT size=2>Sent: Tuesday, December 19, 2000 10:12 PM</FONT> </P><BR> <P><FONT size=2>> Hi all,</FONT> <BR><FONT size=2>> </FONT><BR><FONT size=2>> Does anyone out there have any suggestions as to </FONT><BR><FONT size=2>> why it would take 12 minutes to drop tables.</FONT> <BR><FONT size=2>> Where should I look first?</FONT> <BR><FONT size=2>> </FONT><BR><FONT size=2>> Thanks</FONT> <BR><FONT size=2>> Larry</FONT> <BR><FONT size=2>> -- </FONT><BR><FONT size=2>> Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com" target=_blank>http://www.orafaq.com</A></FONT> <BR><FONT size=2>> -- </FONT><BR><FONT size=2>> Author: Larry Taylor</FONT> <BR><FONT size=2>> INET: ltaylor_at_iq.com</FONT> <BR><FONT size=2>> </FONT><BR><FONT size=2>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT size=2>> San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT size=2>> --------------------------------------------------------------------</FONT> <BR><FONT size=2>> To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT size=2>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT size=2>> the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT size=2>> (or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT size=2>> also send the HELP command for other information (like subscribing).</FONT> </P> <P><FONT size=2>-- </FONT><BR><FONT size=2>Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com" target=_blank>http://www.orafaq.com</A></FONT> <BR><FONT size=2>-- </FONT><BR><FONT size=2>Author: bunyamin karadeniz</FONT> <BR><FONT size=2> INET: bunyamink_at_havelsan.com.tr</FONT> </P> <P><FONT size=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT size=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT size=2>--------------------------------------------------------------------</FONT> <BR><FONT size=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT size=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT size=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT size=2>(or the name of mailing list you want to be removed from). You may</FONT>Received on Tue Dec 19 2000 - 14:39:37 CST
 |
 |