Synonym problems
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 “