I agree completely with you, I was only telling I didn't have any side effect until today. -------Original Message------- From: oracle-l@xxxxxxxxxxxxx Date: 07/21/04 14:14:17 To: oracle-l@xxxxxxxxxxxxx Subject: RE: GLOBAL_NAME change Juan, As with a number of things of this nature, and I'm not just singling = out Oracle here, if the vendor provides a command to do something like = this, there has to be other things that are effected. Now you may never = be adversely affected, but then you may. I remember a backdoor method = of many years ago to rename a column in a table. Problem was that if = you messed it up your database was toast of the charcoal variety. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: Juan Carlos Reyes Pacheco [mailto:jreyes@xxxxxxxxxxxxxxxx] Sent: Wednesday, July 21, 2004 2:02 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: GLOBAL_NAME change Thanks I didn't take attention to the command, but I used the update and = in 4 years didn't have any problem, in a standard database using the = update. =20 -------Original Message------- =20 From: oracle-l@xxxxxxxxxxxxx Date: 07/21/04 13:54:55 To: oracle-l@xxxxxxxxxxxxx Subject: RE: GLOBAL_NAME change =20 Actually you have two back out plans. 1) do the update, which I don't = =3D know the side effects might be. and 2) disable global_names. BTW: I =3D don't use global_names. And in 9i when you create a database the =3D global_name has the domain name attached by default. =20 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA =20 -----Original Message----- From: DENNIS WILLIAMS [mailto:DWILLIAMS@xxxxxxxxxxxxx] Sent: Wednesday, July 21, 2004 1:46 PM To: 'oracle-l@xxxxxxxxxxxxx' Subject: RE: GLOBAL_NAME change =20 =20 Dick - You are correct. The problem is that I have an existing database = =3D that does not have the domain as a part of the GLOBAL_NAME. Near as I can =3D tell, the ALTER DATABASE RENAME command always tacks the domain on. That is = =3D what I want and I intend to use that to change it.=3D20 However, part of making a change is to have a backout plan. I don't =3D like the idea of making a change without a possibility of undoing that =3D change. Thanks to Juan and Scott I have that backout method (UPDATE) in case I = =3D need it, and I hope that I don't. =20 =20 Dennis Williams DBA Lifetouch, Inc. =20 "We all want progress, but if you're on the wrong road, progress means doing an about-turn and walking back to the right road; in that case, the man who turns back soonest is the most progressive."=3D20 -- C.S. Lewis =20 =20 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Goulet, Dick Sent: Wednesday, July 21, 2004 12:44 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: GLOBAL_NAME change =20 =20 The "proper" command is: Alter database rename global_name to =3D3D <whatever>; =20 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA =20 -----Original Message----- From: Scott Canaan [mailto:srcdco@xxxxxxx] Sent: Wednesday, July 21, 2004 11:16 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: GLOBAL_NAME change =20 =20 I usually just go in and update it. Then you can set it to whatever you want.=3D3D3D20 =20 Update global_name Set global_name =3D3D3D3D 'sid'; Commit; =20 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. =20 =20 -----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 =20 I am trying to switch to GLOBAL_NAMES=3D3D3D3DTRUE. If I have two =3D databases =3D3D =3D3D3D and set global_names=3D3D3D3Dtrue on database A, on database B I need to ALTER = =3D =3D3D3D DATABASE RENAME GLOBAL_NAME TO sid.domain. Currently this database just has GLOBAL_NAME as sid.=3D3D3D20 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=3D3D3D3DTRUE on =3D database =3D3D B, nothing should be affected (like its existing links). But it bothers me to make an irrevocable change. =20 Dennis Williams DBA Lifetouch, Inc. =20 Does believing you're the last sane man on the planet make you crazy? Del Spooner in I Robot, played by Will Smith =20 ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------