Yes, directly against the db. The main reason is so that the high water mark is reset on the table. You basically won't have any performance/overhead gains unless you do this.
http://www.adp-gmbh.ch/ora/concepts/space_management/high_water_mark.html Axton On Wed, Dec 9, 2009 at 4:58 PM, Ex Soundgarden <[email protected]>wrote: > ** > 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 >> >> >> >> _Platinum Sponsor: [email protected] ARSlist: "Where the Answers >> Are"_ > > > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ > > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

