Yes..

Truncate table <table name>;

This does not require a commit. Once truncated data cannot be rolled back so
be careful when you use it. It is an immediate action.

Truncate clears the what's commonly known as 'the high water mark' of a
table in a database thus shrinking the size in case it was a huge table
which in your case it definitely is..

Hope this helps..

Joe
  -----Original Message-----
  From: Action Request System discussion list(ARSList)
[mailto:[email protected]]on Behalf Of Ex Soundgarden
  Sent: Wednesday, December 09, 2009 5:58 PM
  To: [email protected]
  Subject: Re: safest and fastest way to delete AR Email records


  **
  Hi Axton,

  I'm not sure where David posted his reply from my question. When you say
truncate table, this means that I would directly go to the db to delete
records?






----------------------------------------------------------------------------
--
  From: Axton <[email protected]>
  To: [email protected]
  Sent: Tue, December 8, 2009 7:06:37 PM
  Subject: Re: safest and fastest way to delete AR Email records

  ** Look into the sql 'truncate table' to empty it initially.  David has
posted what you need for the ongoing maintenance of the data.  While doing
the initial delete, you probably want to look at the email error logs form,
the email attachments form, and all the other email forms.

  Axton


  On Tue, Dec 8, 2009 at 5:56 PM, Ex Soundgarden <[email protected]>
wrote:

    **
    Hi All,

    I've been wandering around searching for some tips on how to delete 3
million records sitting in AR System Email Messages form. What I''m doing
right now is just doing it by batch - deleting 10,000 records every now and
then. From the past, I remember doing it directly in the database by
re-creating the Email Messages table (which eventually dropped all the
records). I had no problem with this.

    I just want to know if there are other ways to delete the records
without going directly to the db?

    Thanks,
    Gabud

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

Reply via email to