Pando - why do you say no? Technically it is feasible, right? I agree that the design/architecture is crapola.

Simply create a view over a dblink and then a synonym for it. Finito.