Database link definition problem
Date: 1997/11/14
Message-ID: <346C41D4.1DEF_at_Horn-Goerwitz.de>#1/1
Hi,
[Quoted] I have a problem with the Oracle Replication. I am using the ORACLE Replication Manager and I can't add a destination to a master group. I allways get the error:
ORA-02085: database link hausarchiv.world
connects to oracle.world
hausarchiv.world is the alias name of the remote database
in the tnsnames.ora.
oracle.world is the default database global_name on both sites.
The server messages book says:
Caution: The database link attempted to connect to a database
with a different name. The name of the database link must be the same as the name of the database. Action: Create a database link with the same name as the database to which it connects.
How can I define such a destination link? What I have done is:
"create public database link hausarchiv.world
using hausarchiv.world"
"create database link hausarchiv.world connect to repadmin
identified by passwd"
Is it OK, the way I did it?
I would appriciate any help!!!!!!!!!!!!! Received on Fri Nov 14 1997 - 00:00:00 CET