Create db link and the parameter global_name
                                                 Last update (2011-05-05 23:00:19)
                                                                                                                   Date added (2008-11-20 14:31:44)

Summary
When you create a database link with a name for example "TEST" then you might notice that oracle adds an extra ".WORLD" or something else.

This extra addition comes from the GLOBAL_NAME of the database. To see what is the GLOBAL_NAME of your database, execute:

SELECT * FROM GLOBAL_NAME;

To change the global_name of you database execute:

ALTER DATABASE RENAME GLOBAL_NAME TO NEW_NAME;

Then if you create a new database link with name XXX, then oracle will add the extra "NEW_NAME", so it will be XXX.NEW_NAME

Be carefull there is the also the parameter "global_names"

SELECT * FROM v$parameter WHERE NAME = 'global_names';

Usually takes a value of FALSE

Tip: When GLOBAL_NAMES=TRUE then the db link name MUST be identical to the global_name of the db to which it connects.