Oracle Database - GLOBAL_NAMES parameter

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.

How to

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

Powered by ComboStrap