Re: Tool to move individual records between two Oracle databases

[Quoted] It' possible to use also another way: the snapshot, if the remote table is a read only one.
Francesco

Norman Dunbar wrote:

> -----Original Message-----
> >>We want to move individual records from a table on one database to the
> same
> >>table on a different machine. This would become a new record in the
> >>destination table. Are there any good tools that enable this to be
> done
> >>easily? What is the easiest way to do this?
>
> Jay,
>
> try the following and apologies in advance if I am teaching my Granny to
> suck eggs !
>
> create database link OTHER connect to USER identified by PASSWORD using
> 'HOST';
>
> OTHER = anything you like but I tend to use the name of the other
> instance.
> USER = the username to which you want to connect (and manipulate).
> PASSWORD = USER's password !
> HOST = the other instance name as per TNSNAMES.ORA.
>
> Now all you do is :
>
> insert into table_at_OTHER select ........;
>
> Regards, Norman Dunbar.
Received on Mon Dec 27 1999 - 12:19:59 CET