Hi,
The quickest way by far is to do the Admin-Delete-Form as Jarl suggest.
Just make sure to export the form and directly related workflow, so you
can reimport these after the delete is done.
Our RRR|Chive tool can do this for you in a robust way with the following
config:
source_server = myserver
source_user = Demo
source_password =
source_form = THE:Form
target_server = myserver
target_form = THE:Form
target_disabledeletefltr = YES
target_clearallrecords = YES
qual = SPLITARSCHEMA
transfertype = COPY
logfile = rrrchive.log
loglevel = NOTICE
progressbar = YES
The good thing with RRR|Chive is that you will get a very good log-file,
and that it will be able to get all record IDs in a single run.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.
> Teh quickest way is to delete the form in Admin tool...
>
> --
> Jarl
>
> 2009/11/19 Sean Harrodine <[email protected]>:
>> **
>> Hi all,
>>
>> I need to delete a form and the 2 million records stored in it.
>>
>> Can anyone elighten me please as to the best and safest way to delete
>> the
>> table with the least amount of impact on the system ie, without spiking
>> the
>> Oracle archive logs.
>>
>> Is it best to remove some or most of the records by using an ARSPerl
>> "DeleteEntry" script first, before blowing the form away in the Admin
>> tool,
>> or is there another way that that i'm not savvy too ?
>>
>> TIA,
>> Sean
>> _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"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"