Re: expdp automation
From: Karth Panchan <keyantech_at_gmail.com>
Date: Mon, 4 Nov 2013 13:31:33 -0500
Message-Id: <AFF532E1-496D-4131-872E-152BB5032A5B_at_gmail.com>
In my experience 1 table data migration DBlink with Create table Table_in_target as select * from table_in_remote.
Date: Mon, 4 Nov 2013 13:31:33 -0500
Message-Id: <AFF532E1-496D-4131-872E-152BB5032A5B_at_gmail.com>
In my experience 1 table data migration DBlink with Create table Table_in_target as select * from table_in_remote.
Build indexes if necessary.
Second choice is Datapump.
We use DBMS_SCHEDULER
Everything depends on OS, DB version.
HTH
Karth
Sent from my IPhone
> On Nov 4, 2013, at 12:57 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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 04 2013 - 19:31:33 CET