Database Administration (MOSC)

MOSC Banner

Synonym created using DBLINK but behving differently

edited Oct 2, 2013 4:25AM in Database Administration (MOSC) 2 commentsAnswered
Hi Team,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center