Hi William,
How about: update global_name set global_name='PIG2';
william wrote:
>
> 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
> --------------------------------------------------------------------------------
> PIG2.PAN
>
> hrm. That's strange.
>
> <snip> rest of post.
Received on Thu May 29 2003 - 04:04:22 CDT
