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 -> Error in Oracle 8i

Error in Oracle 8i

From: <avbpk1_at_yahoo.com>
Date: Tue, 16 Nov 1999 16:27:12 GMT
Message-ID: <80s0kn$5sm$1@nnrp1.deja.com>


Dear Friends,

I have installed oracle 8i on two different machines which have windows NT 4.0 workstation. I tried to create a database link and tried to access data from the database in the neigbouring machine with the following command

SQL> create database LINKNAME
connect to system identified by manger
using SERVICENAME

After creating the link successfully, i tried to execute the following command through sqlplus

SQL> select *from v$session_at_LINKNAME

I am getting the following error message ora-02085: Database link LINKNAME connects to ORACLE

Any suggestions to handle this error and why it is occuring Thanks and Regards
Kumar

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 16 1999 - 10:27:12 CST

Original text of this message

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