Home » RDBMS Server » Server Administration » About Global Name
About Global Name [message #256557] Mon, 06 August 2007 00:22 Go to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
I saw in one document that say global_name=db_name+db_domain.

My db_name=d
and db_domain=d.com so global_name=d.d.com
Ok fine.
Now I changed my database global_name using
alter database rename global_name to change;

now whenever I query,
select database_name from dual or select * from global_name it shows to me global_name=change;

But the db_name and db_domain remains same.

So where went the statement global_name=db_name+db_domain???

Anyone there clarify me.

Report message to a moderator

Re: About Global Name [message #256563 is a reply to message #256557] Mon, 06 August 2007 00:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Messages: 212
No Operating System name or version.
No Oracle version to 4 decimal places.
No code formatting (see http://www.orafaq.com/forum/t/59964/74940/)
No DDL.
No error message.
No help. [You're On Your Own (YOYO)!]

Report message to a moderator

Re: About Global Name [message #256569 is a reply to message #256557] Mon, 06 August 2007 00:54 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
Though for this information no formatting indeed needed.

I saw in one document that says
 global_name=db_name+db_domain.


My db_name=d
and db_domain=d.com
so global_name=d.d.com
Ok fine.
Now I changed my database global_name using
alter database rename global_name to change;


now whenever I query,

select database_name from dual
or 

select * from global_name


it shows to me 
global_name=change;


But the db_name and db_domain remains same as before.

So where went the statement global_name=db_name+db_domain???

Anyone there clarify me.

Report message to a moderator

Re: About Global Name [message #256576 is a reply to message #256569] Mon, 06 August 2007 01:19 Go to previous message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is the default value when you don't set it (global_name) explicitly.

Regards
Michel

Report message to a moderator

Previous Topic: list-list composite partition
Next Topic: Index on aTable
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 23:27:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.