Re: Tool to move individual records between two Oracle databases

Another way is to do the following (on destination site): create database link link using 'remotesite'; -- empty table
create table xxxx as select * from xxxx_at_linkname where 1=2; -- table with selected record:
create table xxxx as select * from xxxx_at_linkname where f1 between 1 and 10;

Francesco Dini wrote:

> 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.

--
-------------------------------------
ADICOM Informatik GmbH
Andreas Michler
Wiesfleckenstr. 34
72336 Balingen
Tel: 07433/9977-0,Fax: -90
E-Mail: Andreas.Michler_at_adicom.de
http:\\www.adicom.de
-------------------------------------