Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: (un) setting global names and db_domain
Bingo! Thanks very much Anthony!
W
Anthony Hogan <ahogan-nospam-_at_iespana.es> wrote in message news:<3ED5CD16.6E0DBFFF_at_iespana.es>...
> 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 - 18:01:24 CDT