Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Why doesn't this simple DATABASE LINK work? Must be something very basic and stupid.

Why doesn't this simple DATABASE LINK work? Must be something very basic and stupid.

From: J.W. <jwngaa_at_att.net>
Date: Tue, 20 Jul 2004 22:21:25 -0500
Message-ID: <19orf0tqsc76188qsk0soq1k7ocqal5fo2@4ax.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US