Oracle Database - GLOBAL_NAMES parameter

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


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap