Global name

From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽

A global name refers to the full name of a database (including its domain) which uniquely identifies it from any other database. An example global name might be FaqDB1.orafaq.com.

If you set the GLOBAL_NAMES parameter to TRUE, all database link names must be valid global names.

If you do not specify a SERVICE_NAME for a database, the service name will default to the database's global name.

To query a database's global name:

SELECT * FROM global_name;

To change a database's global name:

ALTER DATABASE RENAME GLOBAL_NAME TO ...;
Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #