Re: Need an alternate - SYNONYMS

"rohikesh" <rohit.parvatikar_at_gmail.com> wrote:

>Hi All,
>I have a synonym x for a remote database table y. Something like
>"create synonym x for y_at_remote_dblink".
>
>With the change in design, my requireent is to have a similiar synonym
>representing the UNION of two tables y and Z from the remote database.
>Tables Y and Z are on the same instance but on different schema. I have
>created two db links for the same.
>
>Can anyone suggest me as to how do I do that without affecting the
>performance??
>
>I tried one method, wherein I created a view on the union of 2 remote
>tables and then created a synonym with the same name x on this view.
>But this design gives me serious performance issues when the synonym is
>used in subqueries at multiple levels.
>
>Please advise me on this.
>
>Regards,
>rp

If Y and Z are both in the same instance, why 2 DB Links? Grant permission to the link username to access both tables. Received on Thu Oct 27 2005 - 09:27:21 CDT