Robin, I'm sure any method you use that is supported (through the application) will take just as long as the archive process built in, so your only option that I can think of that would be faster would be through DB directly, but doing that of course is not recommended or supported by BMC...so if you decide to go down that path, you go 'alone' from a support perspective.
Regarding taking things out of Remedy DB into another DB....this of course steps outside of the Remedy world anyway...but as Jose suggested, you can do this directly at the DB as well. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Robin Sent: Tuesday, August 07, 2012 1:02 AM To: arslist@ARSLIST.ORG Subject: Help on archiving data. Hi all, Can you please let me know your suggestions on requirements 1 and 2? 1) Transfer records from a regular form to an archive form and delete records from the regular form. I don't want to use built-in remedy archive feature as it consumes lot of resources and takes long time to complete. 2) Transfer records from an archive table to a different database table and delete records from the archive table. The AR System database is oracle. Regards Robin _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"