I usually just go in and update it. Then you can set it to whatever you want.=20 Update global_name Set global_name =3D 'sid'; Commit; Scott Canaan (srcdco@xxxxxxx) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of DENNIS WILLIAMS Sent: Wednesday, July 21, 2004 10:08 AM To: 'oracle-l@xxxxxxxxxxxxx' 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------