Re: how to query between 2 remote databases

When you create the db link, specify a userid and password in the link definition. This makes the userid/password in the FROM clause unnecessary.

HTH,
Brian

kiran wrote:
>
> I do have a dblink between the two remote databases,which I am using in
> my query userid/ password followed by dblink
>
> Thanks
> Kiran
>
> Tim X wrote:
> >>>>>> "kiran" == kiran <kiran.news.invalid_at_web2news.net> writes:
> >
> > kiran> How to query on two tables that are on two different remote
> > kiran> database with a join.
> >
> > kiran> s * f tb1_at_uid/pass_at_db1.world a, tb2_at_uid/pass_at_db2.world b w
> > kiran> a.col1 = b.col2
> >
> > kiran> but this does not work, any idea ?
> >
> > kiran> Thanks
> >
> > Read up about database links. You need to create a db link and then
> > use the syntax
> > select ....
> > from table_at_dblink_name
> > ....
>
> --
> Direct access to this group with http://web2news.com
> http://web2news.com/?comp.databases.oracle.server

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"