Hi,
on a 9i database (DB9) I create a dblink to link to a 11 gR2 database (DB11).
I create it like this :
CREATE DATABASE LINK "DB11" ........
But is automatically created as :
DB11.WORLD
Why ??
Also it does not work and I receive the following :
ORA-02085: database link DB11.WORLD connects to DB11
Cause: a database link connected to a database with a different name. The connection is rejected.
Action: create a database link with the same name as the database it connects to, or set global_names=false.
In Which DB we should set global_names=false ? In DB11 it is FALSE and in DB9 it is TRUE.
Thank for any help.