Home » Other » General » Oracle Database Parameter
Oracle Database Parameter [message #103477] Tue, 04 November 2003 13:37 Go to next message
Messages: 23
Registered: January 2002
Junior Member

How to rename the value of global_name parameter in Oracle8i.

Re: Oracle Database Parameter [message #103490 is a reply to message #103477] Wed, 12 November 2003 09:45 Go to previous message
Messages: 99
Registered: March 2002
Hi Mahendra,

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

Documentation :
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.

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

Current Time: Sun May 26 00:09:40 CDT 2024