| 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
The "proper" command is: Alter database rename global_name to =
<whatever>;
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----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
I usually just go in and update it. Then you can set it to whatever you want.=3D20
Update global_name
Set global_name =3D3D 'sid';
Commit;
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.
-----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=3D3DTRUE. If I have two databases =
=3D
and
set
global_names=3D3Dtrue on database A, on database B I need to ALTER =3D
DATABASE
RENAME GLOBAL_NAME TO sid.domain. Currently this database just has
GLOBAL_NAME as sid.=3D20
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=3D3DTRUE 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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |