Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Why doesn't this simple DATABASE LINK work? Must be something very basic and stupid.
SQL> !tnsping D82
TNS Ping Utility for HPUX: Version 9.2.0.4.0 - Production on 20-JUL-2004 16:28:42 Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/oracle/D82/920_64/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (SDU = 32783) (ADDRESS_LIST =
(ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = srv002)
(PORT = 1582))) (CONNECT_DATA = (SID = D82) (GLOBAL_NAME =
D82.WORLD)))
OK (0 msec)
SQL> create database link xyz using 'D82';
Database link created.
SQL> select * from dual_at_xyz;
SP2-0042: unknown command "xyz" - rest of line ignored.
Received on Tue Jul 20 2004 - 22:21:25 CDT