Re: expdp automation
- From: Karth Panchan <keyantech@xxxxxxxxx>
- To: "nagaraj.chk@xxxxxxxxx" <nagaraj.chk@xxxxxxxxx>
- Date: Mon, 4 Nov 2013 13:31:33 -0500
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@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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
