RE: truncate a table with many extents

  • From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 6 May 2004 11:45:44 -0400

I knew there were good reasons, I just thought I would throw that out so I
could hear them.  Rachel reminded me that there is also the redo log issue.

Thanks,
Ruth

  -----Original Message-----
  From: oracle-l-bounce@xxxxxxxxxxxxx
  [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Adams, Matthew (GE
  Consumer & Industrial)
  Sent: Thursday, May 06, 2004 10:10 AM
  To: oracle-l@xxxxxxxxxxxxx
  Subject: RE: truncate a table with many extents


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


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