Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change global_name from DB

TanteKaetheDec 3 2007 — edited Dec 4 2007
The global name is set to xxx.yyy

I want to change to global name to aaa without any domain (e.g. not to aaa.yyy, aaa.world, etc.)

alter database rename global_name to "aaa";

still keeps the domain name.
(It is a stand alone DB without DB Links or connections from other DBs so the change is ok)

DB Version Oracle 10g

Message was edited by:
TanteKaethe
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 1 2008
Added on Dec 3 2007
7 comments
1,759 views