Re: problem with CREATE DATABASE LINK

From: Lev Smirnov <leo_at_dionis.sura.com.ru>
Date: Wed, 20 Dec 2000 11:26:48 GMT
Message-ID: <91q51k$og6$1@nnrp1.deja.com>

In article <91q3co$n9r$1_at_nnrp1.deja.com>, tshbedford_at_my-deja.com wrote:
> Hi,
> I must be doing something stupid. I can access a table on another PC
> from SQL*Plus by typing 'connect scott/tiger @OtherPC'. Then 'SELECT *
> FROM tablename' shows the expected results.
> I want to do a search of a table on my PC with data taken from the
table
> on the other PC but I can't get a link to work. I can only ever
> seem to be connected to one database or the other. Typing CREATE
> DATABASE LINK linkname USING 'connect scott/tiger @OtherPC' says the
> link is created but doing a 'SELECT * FROM tablename_at_linkname' it says
> ORA-12154 :TNS:could not resolve service name.
>
> I'm an Oracle newbie, could someone tell me exactly what's wrong. Is
> anything to do with both Oracle copies being Personal Edition?
>
> thanks,
>
> Tim
>
> Sent via Deja.com
> http://www.deja.com/
>

Try this:
CREATE DATABASE LINK linkname CONNECT TO scott IDENTIFIED BY tiger USING OtherPC.

If the GLOBAL_NAMES parameter is set to TRUE, linkname should matches the global name of your remote database.

Lev Smirnov
Brainbench MVP for Oracle Admin
http://www.brainbench.com

Sent via Deja.com
http://www.deja.com/ Received on Wed Dec 20 2000 - 05:26:48 CST