Patel, If you know the schema ID's of the forms in question, you can delete the records directly from the database from the associated T, H and B tables. The schema ID's of your forms should be found by querying the arschema table within the ARSystem database and selecting the column schemaid for those forms.
If n is the schema ID for a form that you want to delete the data from you can delete it from the database by: Delete from T<n>; Delete from H<n>; Delete from B<n>; If you are on an Oracle database do not forget to commit at the end of these 3 transactions by running: Commit; You do not need to commit at the end of every delete but you can do this at the end of all the 3 delete operations for that table. Since you have about a million records, it might be a good idea to take the AR System offline while performing these delete transactions. Cheers Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Patel, Kamlesh Sent: Tuesday, September 18, 2007 3:46 PM To: [email protected] Subject: delete mass amount of records from ARS 5.1.2 ** All, I am going through an upgrade plan to 7.x. Before I begin my upgrade I would like to remove lots of data records form our remedy forms. I have a pretty good idea about remedy 5.1.2 patch 1375 data structure. I would like to find out if there is alternative safe and fast way to remove up to 1,000,000 records from couple of remedy forms. Most other forms are relatively small but I would like to employ a fast delete operation to minimize the outage period. Thank You Kamlesh Patel No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.487 / Virus Database: 269.13.22/1015 - Release Date: 9/18/2007 11:53 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
