| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> GLOBAL_NAME change
I am trying to switch to GLOBAL_NAMES=TRUE. If I have two databases and set
global_names=true 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.
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=TRUE 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
 |
 |