RE: GLOBAL_NAME change
- From: "Juan Carlos Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Jul 2004 14:14:45 -0400
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
-----------------------------------------------------------------
Other related posts:
