Database Administration (MOSC)

MOSC Banner

Synonym problems

edited Jul 6, 2017 5:00AM in Database Administration (MOSC) 4 commentsAnswered

Hi there, we are having troubles with one of our databases and someone knows how to help us.

We defined two schemas for a transactional database who collects two different origins. The tables are named the same but for each schema the dblink resolve the origin (For example Origin1.Table1 – Origin2.Table1). The problem appears when we want to use the synonyms. In other servers we define a public synonym for only one schema but in the synonym definition we don’t name it, so the dblink could resolve in each case where table is the correct.

But in this server when we define the same structure it resolve for both origins the same table, but if we use the dblink like “

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