Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> (un) setting global names and db_domain
Dear all -
Let's say for hypothetical reasons, that a database just had a global
name of PIG2 (no .WORLD or .ACME.COM extention) and was quite happy to
be replicated by it's sister database PIG1, and everything was just
fine. Until one day some joker issues a command:
SQL> ALTER DATABASE RENAME GLOBAL_NAME TO BACON.PAN; database links blow up, and a good laugh was had by all. BUT, it turns out that the .PAN extention is seemingly impossible to remove as such:
SQL> ALTER DATABASE RENAME GLOBAL_NAME TO PIG2; SQL> select * from global_name;
GLOBAL_NAME
SQL> ALTER DATABASE RENAME GLOBAL_NAME TO PIG2.POT; Database altered.
SQL> select * from global_name;
GLOBAL_NAME
*.db_domain=''
I can turn global_names on and off until I'm blue in the face with
SQL> alter system set global_names = false scope=both
and watch the spfile change, but nothing changes the GLOBAL_NAME value to just PIG2.
Am I missing something obvious? Thanks in advance -
W Received on Wed May 28 2003 - 21:02:15 CDT