OraFAQ Forum: General » Oracle Database Parameter

Home » Other » General » Oracle Database Parameter

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

Oracle Database Parameter [message #103477]

Tue, 04 November 2003 13:37

Mahendra
Messages: 23
Registered: January 2002

Junior Member

Hi,

How to rename the value of global_name parameter in Oracle8i.

Mahendra

Report message to a moderator

Re: Oracle Database Parameter [message #103490 is a reply to message #103477]

Wed, 12 November 2003 09:45

Epe
Messages: 99
Registered: March 2002

Member

Hi Mahendra,

this should do the trick :
ALTER DATABASE RENAME GLOBAL_NAME TO sales.australia.acme.com;

Documentation :
RENAME GLOBAL_NAME
Specify RENAME GLOBAL_NAME to change the global name of the database. The database is the new database name and can be as long as eight bytes. The optional domain specifies where the database is effectively located in the network hierarchy. Do not use this clause when the database is mounted.
--------------------------------------------------------------------------------
Note: Renaming your database does not change global references to your database from existing database links, synonyms, and stored procedures and functions on remote databases. Changing such references is the responsibility of the administrator of the remote databases.
--------------------------------------------------------------------------------

Cheers,
Epe

Report message to a moderator

Previous Topic:	What is Oracle?
Next Topic:	Batch inserting Serialized date into a BLOB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 03:28:17 CST 2024