Re: truncate a table with many extents

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@xxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: