yeah Ali, your are right but the DBA is not agreeing to it. It needs to be done via remedy so here we are.. I am almost done will update the solution soon.
Thanks, Viki Ali Musa wrote: > > From the application level required a lot of activities (Filter, > Escalation, Form archive). However, this can be done from the database > level using the replication tools (i.e. Oracle Streams processes) or copy, > export and import (i.e. tables such as Txx ,Hxx and Bxx). > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Viki_kulkarni > Sent: Monday, January 31, 2011 7:02 AM > To: arslist@ARSLIST.ORG > Subject: Re: Data Archiving to Vendor form!! will it work? > > Yes I have been thinking in the same way but the DBA team is stressing to > put > it on a different database due to space issues at least thats what they > reason. > > I was trying to do the same task using a view form but facing issues in > push > fields well lets see how things work out. > > > patchsk wrote: >> >> why do you want to create vendor forms. >> You can just save as original form with a different name and use that >> as archive data holder. >> You can write the escalation to do a push field create entry to the >> new form and a delete entry on the old form. >> >> On Jan 28, 6:54 am, Viki_kulkarni <vk0073...@techmahindra.com> wrote: >>> hi Listers, >>> >>> We are trying to enable archiving on ARS 5.01. Yes we are aware that we >>> dont >>> have archiving functionality on ARS 5.0.1 (correct me if wrong). So here >>> is >>> how I am planning to do it and would like you guys to have a look at and >>> with all the experience you have it will be great review. >>> >>> The purpose of archiving is to increase performance while searching and >>> to >>> reduce database size. >>> >>> Hence what I am suggesting is to create a new database with tables same >>> as >>> in AR database. (the T Tables). Then I will create vendor forms for all >>> the >>> forms that I need to archive and map them to the new database tables >>> that >>> I >>> have created similar to the AR T tables using ARDBC plugin. Now I will >>> run >>> an esclation that will move the records from AR server forms to the new >>> vendor forms by a special user AR_ARCHIVER just as it does with the >>> inbuilt >>> archiving.All other users will have only read only access to the archive >>> form as per the inbuilt functionality. >>> >>> Now this will reduce the number of records on the AR Server forms and >>> move >>> it to the archive vendor form. (At least that is the idea) >>> >>> Now I am aware that I will need to keep an eye on all the changes that >>> happens to the base form in terms of field addition and need to >>> replicate >>> on >>> the vendor archive form. But thats ok with us as there wont be any >>> change >>> we >>> guess. >>> >>> So let me know if you guys think this will work? I am currently trying >>> for a >>> small POC for the same will update for the same once I pass/fail and >>> what >>> would be the pros and cons for the same. >>> >>> Just trying to think OOTB :) >>> >>> Thanks, >>> Viki >>> -- >>> View this message in >>> context:http://old.nabble.com/Data-Archiving-to-Vendor-form%21%21-will-it-wor... >>> Sent from the ARS (Action Request System) mailing list archive at >>> Nabble.com. >>> >>> ___________________________________________________________________________ >>> ____ >>> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org >>> attend wwrug11www.wwrug.comARSList: "Where the Answers Are" >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" >> >> > > -- > View this message in context: > http://old.nabble.com/Data-Archiving-to-Vendor-form%21%21-will-it-work--tp30786586p30803749.html > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > > -- View this message in context: http://old.nabble.com/Data-Archiving-to-Vendor-form%21%21-will-it-work--tp30786586p30804250.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"