Re: Databaselink question

abjiang wrote:

> Hi All,
>
> I created database link between two databases using:
>
> CREATE DATABASE LINK foo connect to user identified by pass1 using
> 'DB_Mult';
>
> The "Database link created" messege was shown after executing the
> above line.
>
> However, when I try to run query on the remote database using "select *
> from tableA_at_foo", I got this error messege:
>
> ORA-12154: TNS:could not resolve service name.
>
> How can I fix this probelm? Was it caused by the tnsnames.ora file on
> the remote database?
>
> Thanks in advance for your help!
>
> --
> Posted via http://dbforums.com

Is 'DB_Mult' in the tnsnames.ora of the database in which you created the link?

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