Re: Database Link across 2 databases.

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Wed, 20 Oct 1999 08:13:46 GMT
Message-ID: <_QeP3.86$p%6.2760494@France.EU.net>

Hi Mike !

When you create a database link "database link create" does not means that the db link is ok !

In your example you have forgotten the description string !

You should write something like this
create database link db1 connect scott identified by tiger USING db2;

where db2 in a entry a your local tnsnames.ora !

Regards !

mike seah <mikeseah_at_singnet.com.sg> a écrit dans le message : 7ujsh6$42t$1_at_violet.singnet.com.sg...
> greetings,
> I need to try out oracle basic replication.
> I have created 2 Oracle Databases on my PC.
> I can do a
> "connect system/manager_at_db1" &
> "connect system/manager_at_db2"
> (So TNS is ok)
> From db2, I have done a
> "create database link db1 connect scott identified by tiger;"
> but a
> "create snapshot scott.emp as select * from scott.emp_at_db1"
> fails with error:
> ORA-02019 connect desc for remote database not found.
> what is missing in the Oracle network setup ?
> Any assistance would be appreciated.
> rgds
> mike
>
>
Received on Wed Oct 20 1999 - 03:13:46 CDT