Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: copy certain data from one database to another

Re: copy certain data from one database to another

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 23 Feb 2003 22:10:39 GMT
Message-ID: <Xns932B90396BF21SunnySD@68.6.19.6>


nguyend4_at_hotmail.com (David Nguyen) wrote in news:9a0092d.0302231242.6229b3d6_at_posting.google.com:

> 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?
No
for a while Received on Sun Feb 23 2003 - 16:10:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US