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 -> How to query remote database?

How to query remote database?

From: Tomasz Zalewski <harry_at_computerland.pl>
Date: Fri, 26 Feb 1999 11:36:05 GMT
Message-ID: <36D6881C.2077BC93@computerland.pl>


Hello!

I've got problem querying remote database. After command: select * from user.table_at_remote;
I get a message: "ORA-02019: connection description for remote database not found ".
I don't know what am I doing wrong. I've already defined a database link named 'remote'. I've also put 'remote' in /etc/hosts file ('remote' is the name of the remote server). Then I've defined an appropriote entry in tnsnames.ora file.

I think I am doing some stupid mistake - I am quite new to Oracle. Can you help me with that?

Harry Received on Fri Feb 26 1999 - 05:36:05 CST

Original text of this message

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