I'm having a problem creating a db_link on a WIN2K machine with Oracle 8.1.6. When I create it using the following SQL:
CREATE DATABASE LINK dw_link
CONNECT TO dw1 IDENTIFIED BY dw1
USING 'ORCL';
I get the following error when I try to access it:
select count(*) from user_tables@dw_link;
ORA-02085: database link DW_LINK.LARRY connects to ORCL.LARRY
LARRY is the machine name that I'm doing this on. The Tnsnames.ora file has the following entry for ORCL:
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT=1521)))
(CONNECT_DATA = (SERVICE_NAME = orcl)
)
)
I don't encounter a problem when I do the same thing on solaris.
Thanks in advance!