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,

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-l
Received on Mon Nov 04 2013 - 19:06:50 CET

Original text of this message