Mohammed, data size is huge On Mon, Nov 4, 2013 at 11:36 PM, Mohammed Mehraj Hussain < mhdmehraj@xxxxxxxxx> wrote: > hi, > > If your table count is less then, Do it via database link and create a > script which fetches the data from one db to another at regular intervals. > > > On Mon, Nov 4, 2013 at 11:27 PM, Nagaraj S <nagaraj.chk@xxxxxxxxx> wrote: > >> Dear Gurus, >> >> I have a scenario, Table data from database A should be moved to database >> B on regular interval. If i purge table data on database A it should not >> purge on table B..how can we auto mate or accomplish this ... >> I have planned to do this by scheduling export on windows scheduler and >> to run the purge script once in every week. Please suggest >> >> -Naga >> > > > > -- > Thanks & Regards, > > *Mohammed Mehraj Hussain,* > > Senior Engineer, > > HPS Advanced Solutions, ACS, > > *Honeywell* Technology Solutions, Bangalore, India. > > Phone*:* 080-26588360 Extn: 41272 / Mobile: +91-9845755236 > > >