Tool to move individual records between two Oracle databases
Date: Fri, 24 Dec 1999 10:09:10 -0000
Message-ID: <94690301E74BD311B7F800805FEAD70A3F5658_at_apps.lynx-fsc.co.uk>
-----Original Message-----
>>We want to move individual records from a table on one database to the
same
[Quoted] >>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 Fri Dec 24 1999 - 11:09:10 CET