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 -> DB Link error

DB Link error

From: Scott Harris <sharris_at_sky.net>
Date: 1997/08/20
Message-ID: <5tf3mb$qhg$1@alpha.sky.net>#1/1

I created a DB Link and when I try to access it, I get

ERROR:
ORA-02085: database link SCOTT_PROD02.WORLD connects to ORACLE.WORLD

The oracle message for this error is:
02085, 00000, "database link %s connects to %s"
// *Cause: a database link connected to a database with a different name.

//  The connection is rejected.

// *Action: create a database link with the same name as the database it
// connects to, or set global_names=false. //

I need to leave global_names=true for replication.

Has anyone seen this error?
scott Received on Wed Aug 20 1997 - 00:00:00 CDT

Original text of this message

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