Oracle Database - GLOBAL_NAMES parameter

> Database > Oracle Database

1 - About

GLOBAL_NAMES is a parameter which permit to enforce the database global naming.

FALSE is the default setting for this parameter.

If you set the GLOBAL_NAMES parameter to TRUE (enforces global naming), then you must use the remote database global database name as the name of the link.

3 - How to

3.1 - query it ?

COL NAME FORMAT A12
COL VALUE FORMAT A6
SELECT NAME, VALUE FROM V$PARAMETER
   WHERE NAME = 'global_names'
/
NAME         VALUE
------------ ------
global_names FALSE
Advertising