Re: Queries across databases

Andy Kent schreef:
> Thanks - a DBLINK it is then.
>
> How come this works:
>
> Connect SYSTEM/pword_at_TC6.XYZ.COM;
> select * from dual;
>
> But this gets "ORA-12154: TNS:could not resolve service name"?
>
> create public database link tc6 using 'TC6.XYZ.COM';
> select * from dual_at_tc6;
>
>
> Andy
>

Client and server use different tnsnames.ora files.

Peter Received on Tue Nov 08 2005 - 07:04:57 CST