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

How to rename the value of global_name parameter in Oracle8i.

Mahendra
Re: Oracle Database Parameter [message #103490 is a reply to message #103477] Wed, 12 November 2003 09:45 Go to previous message
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
Previous Topic: What is Oracle?
Next Topic: Batch inserting Serialized date into a BLOB
Goto Forum:
  


Current Time: Fri Mar 29 01:20:54 CDT 2024