Renaming Global Name on 8.1.6

From: weeang <weeang_at_hotmail.com>
Date: 7 Apr 2003 02:36:56 -0700
Message-ID: <c506ca7a.0304070136.30b92690@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??

Thanks n Brgds,
weeang Received on Mon Apr 07 2003 - 04:36:56 CDT