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"

Reply via email to