Re: truncate a table with many extents
- From: DEEDSD@xxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 13 May 2004 08:49:13 -0400
Ah. I was connected as sys, I believe. I'll try it as a ordinary user.
Poor testing practices - tsk, tsk.
"Jonathan Lewis"
<jonathan@xxxxxxxxxxxxx T
co.uk> To:
<oracle-l@xxxxxxxxxxxxx>
cc:
Sent by:
oracle-l-bounce@freelis bcc:
ts.org Subject:
Re: truncate
a table with many extents
05/07/2004 01:49 PM
Please respond to
oracle-l
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
