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

Home -> Community -> Usenet -> c.d.o.tools -> Is Joining tables from two separate oracle databases possible?

Is Joining tables from two separate oracle databases possible?

From: Will Kramer <willardkNOSPAM_at_email.com>
Date: Wed, 28 Feb 2001 20:09:16 -0500
Message-ID: <978r9tklf4sd725p91u985o7u2b8601mr1@4ax.com>

noticed that my post didn't sound like a question...sooooo here again

I'm have oracle 8.1 client installed on my NT box and two databases I have access to via tcp/ip and mention in tnsnames.ora. Is there a way via sql to access both databases at the same time and do a simple join...like lastname to lastname???

If not are there ways of doing this? do I need third party software?

any help , or directions to the right spot would be greatly appreciated.

regards,
Will Kramer Received on Wed Feb 28 2001 - 19:09:16 CST

Original text of this message

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