Are you connected as SYS or SYSTEM, or to an account which has been granted the privilege "unlimited tablespace", rather than the more limited quota unlimited on tablespace X ? 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: <DEEDSD@xxxxxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Friday, May 07, 2004 3:53 PM Subject: Re: truncate a table with many extents I did a truncate on a table with 10,000 (8k) extents in a LMT on 9.2.0.4 on solaris, with 10046 level 8 trace enabled. I didn't see tsq$ - am I missing something? ---------------------------------------------------------------- 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 -----------------------------------------------------------------