Newbie question: Creating database link

From: Griffin <chengcs_at_my-deja.com>
Date: Tue, 25 Jan 2000 04:25:59 GMT
Message-ID: <86j8ki$kk8$1@nnrp1.deja.com>

I want to create a database link on a Solaris Oracle (say A) thru another Solaris Oracle (B) connected from an NT client. If I just type:

create database linke <whatsoever>

connect to <userid> identified <passwd> using '<connect>'

and <connect> is the string stored in local client tnsnames.ora to connect to server (A). This will raise an error "TNS cannot resolve service" when I try to exec a query.

Or when <connect> is the same as string stored on the server (B) to connect to (A), an error ORA-02085 is rasied.

Any help would be appreciated.

Griffin.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 24 2000 - 22:25:59 CST