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 -> Re: Joining tables from two separate oracle databases possible

Re: Joining tables from two separate oracle databases possible

From: Robert John Andersen <anderman_at_anderware.com.nospam>
Date: Sat, 03 Mar 2001 03:35:23 GMT
Message-ID: <%DZn6.16056$__6.4078674@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 Fri Mar 02 2001 - 21:35:23 CST

Original text of this message

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