RE: GLOBAL_NAME change

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Wed, 21 Jul 2004 13:21:05 -0400
Message-ID: <AFF54B073FF15849B53E32E67EE860760144EFAC@ENHBGPRI11.PA.LCL>

I ran into this and posted this as a suggestion for improvement back to = Oracle to fix it. I consider it a bug not to be able to alter it back = to the original. I used this on clone databases before I learned how to = change the dbname and dbid using NID. Although I wouldn't recommend it = because I have no idea what else might be affected you can simply update = the table global_names back to the original.=20

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DENNIS WILLIAMS Sent: Wednesday, July 21, 2004 10:08 AM
To: 'oracle-l_at_freelists.org'
Subject: GLOBAL_NAME change

I am trying to switch to GLOBAL_NAMES=3DTRUE. If I have two databases = and set
global_names=3Dtrue on database A, on database B I need to ALTER = DATABASE
RENAME GLOBAL_NAME TO sid.domain. Currently this database just has GLOBAL_NAME as sid.=20

Now my question. If something goes wrong, does anyone know a way to change the GLOBAL_NAME back to just plain sid? It seems that the ALTER DATABASE RENAME GLOBAL_NAME command always helpfully slaps the domain on = the
sid. In theory since I'm not changing GLOBAL_NAMES=3DTRUE on database B, nothing should be affected (like its existing links). But it bothers me = to
make an irrevocable change.

Dennis Williams
DBA
Lifetouch, Inc.

Does believing you're the last sane man on the planet make you crazy?

Del Spooner in I Robot, played by Will Smith

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Wed Jul 21 2004 - 12:17:40 CDT