Re: copy certain data from one database to another

someone please clarify for me

I have
DATABASE1
DATABASE2
USER1
USER2
SID1
SID2 now I log on to SQL of DATABASE2 and do this:

create database link <link_1> for <USER1> identified by <pwd> using '<SID1>';

insert into <table> * from <table>@<link_1> where id != id@<link_1>;  

is this going to work? and what is id and id@<link_1> for?

thanks

David Received on Sun Feb 23 2003 - 14:42:36 CST