OraFAQ Forum: Unix » Changeing a global database name

Home » Infrastructure » Unix » Changeing a global database name

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

Changeing a global database name [message #122964]

Thu, 09 June 2005 06:34

snagra
Messages: 23
Registered: March 2005

Junior Member

I need to change a global databse name because I set it to the same one on another machine without thinking.

If I have say devf@abc.com where devf is the SID. Does abc.com have to exist somewhere or can it be anything I want?

Whats the command to change the Global database name ?

Report message to a moderator

Re: Changeing a global database name [message #122993 is a reply to message #122964]

Thu, 09 June 2005 08:51

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

You can set it to almost anything you like:

SQL> ALTER DATABASE RENAME GLOBAL_NAME TO testdb.heaven.com;

Database altered.

Best regards.

Frank

Report message to a moderator

Re: Changeing a global database name [message #123081 is a reply to message #122993]

Thu, 09 June 2005 16:19

andrew again
Messages: 2577
Registered: March 2000

Senior Member

The only place I've seen the global database name used is on a remote database to ensure that it's DB links conform to GLOBAL_NAMES=true (if set).

See the database and instance names in v$database and v$instance too...

Report message to a moderator

Previous Topic:	Usefull book
Next Topic:	Coping Schemas

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 11:56:29 CDT 2024