Re: truncate a table with many extents

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 7 May 2004 21:27:02 +0100
Message-ID: <004d01c43471$ab83d8f0$7102a8c0@Primary>

Given the point about quotas, and tablespace privileges, then if the table belongs to an account which has a quota (even an unlimited quota) on a tablespace, then yes. If the account doesn't have a quota control on the tablespace, then it probably doesn't matter. (In fact, truncate may be a little faster because of all the AW and CDC stuff that might have been installed by accident).

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated May 1st

Original Message ----- From: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us> To: <oracle-l_at_freelists.org> Sent: Friday, May 07, 2004 8:32 PM Subject: RE: truncate a table with many extents

Is the upshot of all this, if you are using 9i (or above) a drop should be faster than a truncate if you don't need to truncate to save the stuff that goes along with the table?

Ruth

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 Fri May 07 2004 - 15:25:54 CDT