Creating a Database Link to a Remote Database
From: Jamie Painter <jdpainter_at_mindspring.com>
Date: 2000/01/28
Message-ID: <86sve2$4ki$1_at_nntp5.atl.mindspring.net>#1/1
Date: 2000/01/28
Message-ID: <86sve2$4ki$1_at_nntp5.atl.mindspring.net>#1/1
[Quoted] I am having a problem creating connecting to a remote database. I can create [Quoted] the database link with no problem. The statemenet that I used is below:
SQL> create database link vishay.mcasey connect to vishays identified by vishays using 'vishay.world';
However when I try to query the remote database I get the following error:
ERROR at line 1:
ORA-02085: database link VISHAY.MCASEY connects to ORACLE.WORLD
Any Ideas??????? Received on Fri Jan 28 2000 - 00:00:00 CET