Re: Database Link between Oracle8 and Oracle 7.3

Alan Douglas <alandouglas_at_mailexcite.com> schrieb in im Newsbeitrag: EsY23.2187$y6.1394885_at_WReNphoon3...
> [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.

Thank you for submitting this message. Because that helps. The helping hint was

   global_names=false
I looked in the init.ora of my oracle 7.3 database there I did not find this command.
Kind regards for the quick support.
Nicolas Bronke Received on Wed May 26 1999 - 15:41:34 CDT