OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » About Global Name

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

About Global Name [message #256557]

Mon, 06 August 2007 00:22

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

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

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

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

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 12 22:20:29 CDT 2026