Re: expdp automation
From: Mohammed Mehraj Hussain <mhdmehraj_at_gmail.com>
Date: Mon, 4 Nov 2013 23:36:50 +0530
Message-ID: <CA+jfRHx21rAi3nZ7nM5QD9WmQhroh8iBEYZw2xsTd+OE3f8SEw_at_mail.gmail.com>
hi,
Date: Mon, 4 Nov 2013 23:36:50 +0530
Message-ID: <CA+jfRHx21rAi3nZ7nM5QD9WmQhroh8iBEYZw2xsTd+OE3f8SEw_at_mail.gmail.com>
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_at_gmail.com> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 04 2013 - 19:06:50 CET