Wednesday, March 28, 2018

Use of GLOBAL_NAMES parameter with respect to DB links

GLOBAL_NAMES parameter is a combination of the database name and the domain name like “rose.corp.com”, in which “rose” is the database name and “corp.com” is the domain name.

When you set the initialization parameter GLOBAL_NAMES to TRUE, the database ensures that the name of the database link is the same as the global database name of the remote database.

For example, if the global database name for rose is rose.corp.com, and GLOBAL_NAMES is TRUE, then the link name must be called rose.corp.com.

If you set the initialization parameter GLOBAL_NAMES to FALSE, then you are not required to use global naming. You can name the database link whatever you want. For example, you can name a database link to rose.corp.com as flower.

No comments:

Post a Comment