Re: querying over multiple database links

From: Krzysztof Cierpisz <ciapecki_at_gmail.com>
Date: Wed, 6 Jul 2011 13:01:28 -0700 (PDT)
Message-ID: <d02abfed-a7e3-4dd8-99e7-aa3872d4fe63_at_t9g2000vbv.googlegroups.com>

On Jul 6, 7:35 pm, joel garry <joel-ga..._at_home.com> wrote:

> It's been too long since I've done this, but I think what you want to
> do is desc <yourpublicsynonym>_at_<remove_database2> (or select * from
> user_db_links_at_<remote_database2>, then if you can see that, you have
> to make some bizarro usage with quotes and _at_ signs like desc
> 'table_name_at_<remote_database>'@<remote_database2>

I tried but cannot get it working, I googled but cannot find anything. Are you sure it's possible?

--
chris

Received on Wed Jul 06 2011 - 15:01:28 CDT