Another thing you want to keep in mind is relationships. Make sure you delete any relationship the record has to other tables, otherwise your going to have a lot of orphan records in other tables. So it's possible to do through SQL commands, and a lot quicker, but requires you to do a lot of planning.
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Tuesday, September 18, 2007 7:54 PM To: [email protected] Subject: Re: delete mass amount of records from ARS 5.1.2 ** 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 __________ NOD32 2534 (20070917) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
