Re: GLOBAL_NAME

After you recreate the database you have to use ALTER DATABASE RENAME GLOBAL_NAME command to change the global name. But make sure all your db links and other references are changes too.

HTH
Venkat

>I recently created a new instance by copying from existing instance: copied
>data files to new location, created init.ora, issue command create database
>.. etc.
>
>But when the new instance is started and I did a
> select *
> from global_name;
>
>I get the old value of YASFIN.WORLD. I am expecting the new value
>YASFNPRD.WORLD.
>
>Can anyone tell me more about GLOBAL_NAME, when was it created etc, and in
>this case why was it not reflecting the value i am expecting.
>
>What should I do to make global_name reflect the correct value?
>
>Thanks!
>
>Regards,
>Tse Chong
Received on Mon Jun 01 1998 - 13:12:19 CDT