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