Synonym created using DBLINK but behving differently
We have A,B,C schemas having local DBLINK REP_LINK connecting to different database A-DB,B-DB,C-DB. But when we call a synonym (GLOBAL is the package name called) it failes when one of the database is down. If we prefix the SCHEMA with GLOBAL Package it is working fine.
Suppose if A-DB is down and I am calling a synonym created on package GLOBAL from B schema which uses DBLINK of B-DB it fails stating A.A-DB@A-DB is unable to connect. But if we hardcode the SCHEMA B.GLOBAL then its working fine.
We cannt hard code the schema. Can you let me know is there any work around for prefixing the schdma to a synonym created using DB_LINK.