RE: Urgent! Taking a Long Time to drop Tables

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Tue, 19 Dec 2000 14:04:04 -0600
Message-Id: <10715.124954@fatcity.com>

I believe there is.

-----Original Message-----
From: Alex Hillman [mailto:alex_hillman_at_physia.com] Sent: Tuesday, December 19, 2000 1:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: Urgent! Taking a Long Time to drop Tables

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
<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


<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).

Received on Tue Dec 19 2000 - 14:04:04 CST