Re: join between two tables of 2 differents databases mounted on 2 differents servers

Laurent RUHLMANN wrote:

> Hi,
>
> I would like to to create a join select statement between 2 tables each one
> being on different databases and different servers. I have created a link
> between the two databases but the remote table is not recognised when I do
> the select statement.
>
> Any idea ?
>
> Thanks,
>
> Laurent

Lots of them. They all start with the fact that you didn't tell us anything particularly useful. Lets start with the basics:

1. What version and edition of Oracle?
2. What is the name of the database link?
3. Did you test the database link to see if it was working?
4. How?
5. What SQL did you write?
6. "is not recognized" is not an Oracle error message ... what message did you actually get?

Why would you think anyone could possibly help you from what you posted? Do you think we can just look over your shoulder or that we sneak onto your computer and test stuff when you look away?

My thought ... you either wrote syntactically incorrect SQL or your database link is invalid.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)