Re: GLOBAL_NAMES Domain is not going away (forcing a change)

Thank you Andy, but I don't have, I checked, is a new problem I didn't have.

something important I found is the select after the update if you apply this solution.

UPDATE SYS.props$ SET value$='ABVP' WHERE name='GLOBAL_DB_NAME';

  select * from global_name; --ABVP

COMMIT;   select * from global_name; --ABVP

alter database RENAME global_name TO XXX; select * from global_name; --XXX

alter database RENAME global_name TO ABVP;

  select * from global_name; --ABVP

2017-09-20 17:07 GMT-04:00 Andy Klock <andy_at_oracledepot.com>:

>
>
> On Tue, Sep 19, 2017 at 11:49 AM, Juan Carlos Reyes Pacheco <
> jcdrpllist_at_gmail.com> wrote:
>
>> select * from global_name;
>> ABVP.WORLD
>>
>> The domain always stays
>>
>> alter database RENAME global_name TO XXX;
>> xxx.world
>>
>
> Is it possible that you have default_domain defined in your sqlnet.ora?
> Perhaps that triggers what you are experiencing.
>
> Andy K
>

--
http://www.freelists.org/webpage/oracle-l