GLOBAL_NAMES Domain is not going away (forcing a change)
Date: Tue, 19 Sep 2017 11:49:44 -0400
Message-ID: <CAGYrQyu2EpX8vT5ja+ow8WSe9c=hAy6bHsPnh_M9iFUV_ptzug_at_mail.gmail.com>
Please, if you know a better way :)
I didn't found solution so I fixed in this way:
db_domain is null
a domain is added and can't be set to null
select * from global_name;
alter database RENAME global_name TO XXX;
xxx.world
ABVP.WORLD
The domain always stays
Changing domain the domain stays again
alter database RENAME global_name TO XXX.com.bo;
select * from global_name;
XXX.com.bo
alter database RENAME global_name TO abvp;
select * from global_name;
abvp.com.bo
Chaging directly in the sys table, and rexecuting change to get a correct change in the database dictionary:
UPDATE SYS.props$ SET value$='ABVP' WHERE name='GLOBAL_DB_NAME';
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
Thank you :)
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 19 2017 - 17:49:44 CEST