Re: Joining tables from two separate oracle databases possible

try either:

create database link my_link2 using 'scopus1';

or

create database link my_link2
connect to mdixxi
identified by mdixxi
using 'scopus1';

then:

select xxx,yyy from table_at_scopus1;

the first create statement will cause any connections to connect as the person running the sql statement
the second will cause any connections to connect as the user identified in the connect to clause.

Shannon

"Robert John Andersen" <anderman_at_anderware.com.nospam> wrote in message news:%DZn6.16056$__6.4078674_at_typhoon.southeast.rr.com...
> In article <v2m0at4e30k82c69mro8jg8g0bt3fjvlql_at_4ax.com>, "Will Kramer"
> <willardkNOSPAM_at_email.com> wrote:
>
> > Ok tried what you said...and here's what I got. I'm still missing
 something.
> >
> >
> > 1* create database link my_link2 using 'mdixxi/mdixxi_at_scopus1.world'
> > SQL> /
> >
>
> Try taking this instead 'scopus1' or 'scopus1.world' whichever is in your
> tnsnames file.
>
> RJA
Received on Wed Mar 14 2001 - 08:45:41 CST