Re: (un) setting global names and db_domain

And I would like to point out to oracle documentation folks that searching for this method yields nothing:

http://otn.oracle.com/pls/db92/db92.drilldown?remark=&word=update+global_name&book=&preference=

http://otn.oracle.com/pls/db92/db92.drilldown?remark=AND+hint&word=update+and+global_name&book=&preference=

thanks again - 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:12:04 CDT