Sender: tcross@tiger.rapttech.com.au Newsgroups: comp.databases.oracle.server Subject: Re: how to query between 2 remote databases References: <47051N880@web2news.com> From: Tim X Reply-To: timx@spamto.devnul.com Date: 07 Jul 2003 17:39:08 +1000 Message-ID: <87el12dbvn.fsf@tiger.rapttech.com.au> Lines: 25 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii NNTP-Posting-Host: ppp597.nsw.padsl.internode.on.net X-Trace: duster.adelaide.on.net 1057562695 ppp597.nsw.padsl.internode.on.net (7 Jul 2003 16:54:55 +0950) Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!enews.sgi.com!news.xtra.co.nz!news.mel.connect.com.au!news.ade.connect.com.au!duster.adelaide.on.net!not-for-mail Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:237036 >>>>> "kiran" == kiran writes: kiran> How to query on two tables that are on two different remote kiran> database with a join. kiran> s * f tb1@uid/pass@db1.world a, tb2@uid/pass@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@dblink_name .... -- 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!