[8.0.5-cog3] /itc $ oerr ora 2085
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.
//
ABOVE IS ORACLE'S EXPLANATION
The "*Cause" above seems to be the exact opposite of what's in the message
text.
I suspect there is a problem if you use the SID as a database link name.
(Can anyone confirm this?)
SQLPLUS accepts the form @<sid> when you connect to a database, and SQL
statements can use the form
<tablename>@<dblink> to refer to a table in whatever database <dblink>
points to.
-**** Posted from RemarQ, http://www.remarq.com/?a ****-
Search and Read Usenet Discussions in your Browser - FREE -
Received on Wed May 26 1999 - 14:59:53 CDT
