Re: how to query between 2 remote databases

>>>>> "kiran" == kiran <kiran.news.invalid_at_web2news.net> writes:

 kiran> I do have a dblink between the two remote databases,which I am  kiran> using in my query userid/ password followed by dblink

 kiran> Thanks Kiran

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

 kiran> -- Direct access to this group with http://web2news.com  kiran> http://web2news.com/?comp.databases.oracle.server

Try it this way -

CREATE DATABASE LINK link_name
CONNECT TO username
IDENTIFIED BY password
USING database.world

SELECT * FROM my_table_at_link_name;

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!