Re: truncate a table with many extents

  • From: Tim Johnston <tjohnston@xxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 06 May 2004 10:00:28 -0400

It wouldn't save him any time...  It will still have to perform all the 
fet$/uet$ work...


Ruth Gramolini wrote:

>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...
>  -----Original Message-----
>  [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Adams, Matthew (GE
>  Consumer & Industrial)
>  I'm truncating a table with around 14,000 extents
>  on a 7.3.4 database on a slow machine.
>  (Please don't ask how this happened, it's too=20
>  painful to re-live.)
>  Is there anyway to determine how far the truncate
>  has gotten at any given point?  I thought I might see
>  changes in sys.fet$ or sys.uet$ as extents are de-allocated,
>  but I'm not seeing that.
Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: