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@xxxxxxxxxxxxxxx>:
On Tue, Sep 19, 2017 at 11:49 AM, Juan Carlos Reyes Pacheco <
jcdrpllist@xxxxxxxxx> 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
