What is the significance of Oracle Parameter Global_names=TRUE?

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
Global_names is a Boolean parameter which means the value of the parameter can be TRUE or FALSE. By default the value of the parameter is FALSE. If you set this parameter value as TRUE, the name of the database link must be the same name of the remote database which they are connecting.
If the value of the parameter is FALSE, then there will not be any check is performed on the database links.

You can set the parameter value in session level or system level.
ALTER SESSION SET global_names=TRUE;
ALTER SYSTEM SET global_names=TRUE;

How to check the parameter value?
show parameter global_names
SELECT VALUE FROM V$PARAMETER WHERE NAME='global_names';

_____________________________________________________________________________________________________________________

A visitor from Maryland viewed 'How to create and remove soft link (symbolic) in S' 30 mins ago
A visitor from Florida viewed 'How to disable all constraints on a table or schem' 38 mins ago
A visitor from Lublin viewed 'Script to Find and Cleanup Orphaned Datapump Jobs' 58 mins ago
A visitor from Henan viewed 'ORA-00059: maximum number of DB_FILES exceeded - F' 1 hr 22 mins ago
A visitor from Lublin viewed 'Script to Find and Cleanup Orphaned Datapump Jobs' 1 hr 24 mins ago

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-25 All Rights Reserved | Site Map | Contact | Disclaimer