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_01C069F4.379BA990
Content-Type: text/plain;
charset="iso-8859-1"
There is no rollback on drop also. I do not think there is any rollback on any DDL.
Alex Hillman
-----Original Message-----
From: Cherie_Machler_at_gelco.com [mailto:Cherie_Machler_at_gelco.com]
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
Larry,
It's because of the rollback, probably.
It would be quicker to truncate the tables
first and then drop them after they have
been truncated. There is no rollback
on truncate.
Cherie
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Cherie_Machler_at_gelco.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). ------_=_NextPart_001_01C069F4.379BA990 Content-Type: text/html; charset="iso-8859-1"Received on Tue Dec 19 2000 - 13:45:19 CST
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0">
<TITLE>RE: Urgent! Taking a Long Time to drop Tables</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>There is no rollback on drop also. I do not think there is any rollback on any DDL.</FONT>
</P>
<P><FONT SIZE=2>Alex Hillman</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Cherie_Machler_at_gelco.com [<A HREF="mailto:Cherie_Machler_at_gelco.com">mailto:Cherie_Machler_at_gelco.com</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>Larry,</FONT>
</P>
<P><FONT SIZE=2>It's because of the rollback, probably.</FONT>
</P>
<P><FONT SIZE=2>It would be quicker to truncate the tables</FONT>
<BR><FONT SIZE=2>first and then drop them after they have</FONT>
<BR><FONT SIZE=2>been truncated. There is no rollback</FONT>
<BR><FONT SIZE=2>on truncate.</FONT>
</P>
<P><FONT SIZE=2>Cherie</FONT>
</P>
<BR>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: </FONT>
<BR><FONT SIZE=2> INET: Cherie_Machler_at_gelco.com</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>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>
![]() |
![]() |