Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help needed with database links

Re: Help needed with database links

From: Frank an der Heiden <fh_at_energotec.de>
Date: Tue, 11 Jan 2000 08:56:41 +0100
Message-ID: <85endb$cup$1@oxygen.technet.net>


hi jan,

i have the same problem creating a mulimaster replication environment.

i use the replication manager to create/configure the multimaster environment.
when i want to finish, i get the error message: ora-02082

--> from the oracle online docu BEGIN

ORA-02082: a loop-back database link must have a connection qualifier Cause: An attempt was made to create a database link with the same name as the current database.

Action: This database link needs a trailing qualifier to make the name unique. These qualifiers are operating system-specific. See your operating system-specific Oracle documentation for more information about creating database links.
<----- END
the replacation manager wants to create public database links, using the sql command "create public database link oracle.world using <using-klausel>",
but this seem to fail.

i am running oracle 8 enterprise edition for win nt 4.0 sp6a

if you know, how to solve this, please let me know

thanx
frank

ps: what the hell is a trailing qualifier ;-) Received on Tue Jan 11 2000 - 01:56:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US