| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_dazasoftware.com]
Sent: Wednesday, July 21, 2004 2:02 PM
To: oracle-l_at_freelists.org
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_at_freelists.org
Date: 07/21/04 13:54:55
To: oracle-l_at_freelists.org
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_at_LIFETOUCH.COM]
Sent: Wednesday, July 21, 2004 1:46 PM
To: 'oracle-l_at_freelists.org'
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Goulet, Dick
Sent: Wednesday, July 21, 2004 12:44 PM
To: oracle-l_at_freelists.org
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_at_rit.edu]
Sent: Wednesday, July 21, 2004 11:16 AM
To: oracle-l_at_freelists.org
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_at_rit.edu)
(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_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
=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
-- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 - 13:13:50 CDT
 |
 |