Effect of setting GLOBAL_NAMES in database
Hi.What will happen if GLOBAL_NAMES is provided a True value in database
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Chintan RathodPosted Dec 22, 2011, 12:38 AM
GLOBAL_NAMES specifies whether a database link is required to have the same name as the database to which it connects.
Parameter
Description
Parameter type
Boolean
Default value
false
Modifiable
ALTER SESSION, ALTER SYSTEM
Range of values
true | false
Basic
No
If the value of
GLOBAL_NAMESisfalse, then no check is performed. If you use or plan to use distributed processing, then Oracle recommends that you set this parameter totrueto ensure the use of consistent naming conventions for databases and links in a networked environment.