Rabi, Thank You for your input. I will add this to my steps.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rabi Tripathi Sent: Wednesday, September 19, 2007 8:32 AM To: [email protected] Subject: Re: delete mass amount of records from ARS 5.1.2 Removing indexes would speed up the process, no matter you are doing it from AR System or database. You can rebuild them later. If you are doing it from database, one way would be to copy tables DDL statement, drop the table and rebuild it. In case you want to preserve any data, you can selectively export it to an identical temp table, drop the original table and then rename the temp table back. If you work on forms directly at database table, you will need to reference ARS 5 Database Reference guide to see the data dictionary to understand the table relationships for a ARS forms and repeat the process on all tables. With version 5, it shouldn't be too bad. Example: For Form A. Say main table is T20 (in arschema table) H20 will be status history table B20 will be attachment tables B20C536870917 will be the table where 0 length char field with ID C536870917 will be etc T20 > 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" > ________________________________________________________________________ ____________ Don't let your dream ride pass you by. Make it a reality with Yahoo! Autos. http://autos.yahoo.com/index.html ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
