Re: querying over multiple database links
From: gazzag <justified_at_jamms.org>
Date: Wed, 6 Jul 2011 02:54:11 -0700 (PDT)
Message-ID: <aeec7aa6-f0be-4d05-bdf0-650814e68235_at_j15g2000yqf.googlegroups.com>
On Jul 5, 5:20 pm, Krzysztof Cierpisz <ciape..._at_gmail.com> wrote:
>
> the table is not on <remote_database> -> I have no direct access to
> <remote_database>
> I have only indirect access over a db_link from "another" database to
> <remote_database>. I have a very limited access on this "another"
> database so I cannot create any objects there.- Hide quoted text -
>
> - Show quoted text -
Date: Wed, 6 Jul 2011 02:54:11 -0700 (PDT)
Message-ID: <aeec7aa6-f0be-4d05-bdf0-650814e68235_at_j15g2000yqf.googlegroups.com>
On Jul 5, 5:20 pm, Krzysztof Cierpisz <ciape..._at_gmail.com> wrote:
>
> the table is not on <remote_database> -> I have no direct access to
> <remote_database>
> I have only indirect access over a db_link from "another" database to
> <remote_database>. I have a very limited access on this "another"
> database so I cannot create any objects there.- Hide quoted text -
>
> - Show quoted text -
Apologies Krzysztof, I should have read your post more carefully!
Can you not create a database link direct to remote1 from your local db using the same credentials as the database link from remote2 to remote1?
HTH
-g
Received on Wed Jul 06 2011 - 04:54:11 CDT