Re: Renaming Global Name on 8.1.6

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Mon, 7 Apr 2003 20:22:08 +0100
Message-ID: <3e91e2b4_2@mk-nntp-1.news.uk.worldonline.com>

"weeang" <weeang_at_hotmail.com> wrote in message news:c506ca7a.0304070136.30b92690_at_posting.google.com...
> Hi,
>
> I have an Oracle 8.1.6 running on HP-UX.
>
> The following parameters are set:
> DB_DOMAIN = '' (empty)
> DB_NAME = mkml
> GLOBAL_NAME = TRUE
>
> Thus, when I perform
> select * from global_name;
> => the result is: MKML.US.ORACLE.COM
>
> However, when i rename it:
> alter database rename global_name to mkml;
> commit;
> select * from global_name;
> => the result is still: MKML.US.ORACLE.COM
>
> WHY is it like that??? How do I rename it to MKML only??
>

The GLOBAL_NAME is the db name with a dot and the db_domain. From your example it looks like the db_domain defaults to US.ORACLE.COM if you try to set it null or empty. Generally I've seen .world as Oracle's default db_domain.

FWIW, I generally set db_domain to the real domain. So for example, if I'm working at acme.com I set db_domain to ACME.COM - so if I have a database called MKML its GLOBAL_NAME would be MKML_at_ACME.COM

Then, with GLOBAL_NAMES = TRUE (note the 'S'), db links from elsewhere must have the same name as the global name of the target. So if, from another database, I want to make a link to mkml, the db link name must be MKML_at_ACME.COM This seems a sensible approach to me. Or am I missing something?

Regards,
Paul

P.S. Spammers: I doubt that there's a real MKML_at_ACME.COM (g) Received on Mon Apr 07 2003 - 14:22:08 CDT