Database link definition problem

From: Panagiotis Kotsilas <panos_at_Horn-Goerwitz.de>
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

Original text of this message