RE: truncate a table with many extents

  • From: "Adams, Matthew (GE Consumer & Industrial)" <MATT.ADAMS@xxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 6 May 2004 10:10:11 -0400

I was preferring to truncate so I wouldn't loose the=20
indexes and grants on the table.=20

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Ruth Gramolini
Sent: Thursday, May 06, 2004 9:56 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: truncate a table with many extents


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...

Ruth

  -----Original Message-----
  From: oracle-l-bounce@xxxxxxxxxxxxx
  [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Adams, Matthew (GE
  Consumer & Industrial)
  Sent: Wednesday, May 05, 2004 5:28 PM
  To: oracle-l@xxxxxxxxxxxxx
  Subject: truncate a table with many extents


  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=3D20
  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.



  ----
  Matt Adams - GE Appliances - matt.adams@xxxxxxxxxxx
  Just once, I wish we would encounter an
  alien menace that wasn't immune to bullets.=3D20
             - The Brigadier
  ----------------------------------------------------------------
  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
-----------------------------------------------------------------
----------------------------------------------------------------
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: