Re: querying over multiple database links

From: gazzag <>
Date: Wed, 6 Jul 2011 02:54:11 -0700 (PDT)
Message-ID: <>

On Jul 5, 5:20 pm, Krzysztof Cierpisz <> 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?

-g Received on Wed Jul 06 2011 - 04:54:11 CDT

Original text of this message