Re: Global Names / SqlNet/Net8

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 11 Jun 1999 18:22:59 GMT
Message-ID: <376b538d.11179054@newshost.us.oracle.com>

A copy of this was sent to jholden_at_voyager.net (J Holden) (if that email address didn't require changing) On Fri, 11 Jun 1999 18:13:01 GMT, you wrote:

>Am getting the following error when I tried to have a database link
>between two machines.
>
>ORA-02085: database link MACH1.WORLD connects to XXX.WORLD
>
>I looked up the error and it says to set global_names=false but where
>would I do that at?
>
>Thanks
>
>J

You can do one of two things.

1. alter system set global_names=false; at the sql prompt. do it in both instances.
2. rename the database XXX.WORLD to be MACH1.WORLD if thats what its name should be. alter database rename global_name to MACH1; at the sql prompt

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/

Current article is "Fine Grained Access Control", added June 8'th  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Jun 11 1999 - 13:22:59 CDT