RE: truncate a table with many extents
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 6 May 2004 10:45:05 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Khedr, Waleed
Sent: Thursday, May 06, 2004 10:03 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: truncate a table with many extents
Drop will be as bad as truncate
-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini@xxxxxxxxxxxxxxx]
Sent: Thursday, May 06, 2004 9:56 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
