Re: Queries across databases

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 Received on Tue Nov 08 2005 - 04:47:47 CST