RE: truncate a table with many extents

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 6 May 2004 10:45:05 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AB19@usahm018.exmi01.exch.eds.com>

If I am not mistaken dropping the table should be much worse than using truncate because the use of drop would greatly increase the amount of undo that Oracle has to keep track of.

• Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Khedr, Waleed Sent: Thursday, May 06, 2004 10:03 AM
To: oracle-l_at_freelists.org
Subject: RE: truncate a table with many extents

Drop will be as bad as truncate

-----Original Message-----

From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us] Sent: Thursday, May 06, 2004 9:56 AM
To: oracle-l_at_freelists.org
Subject: RE: truncate a table with many extents

Why can't you just drop and recreate the table? Since I know you are an exceptional DBA this is probably a stupid question but...

Ruth

  -----Original Message-----  

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu May 06 2004 - 09:48:09 CDT