Re: querying over multiple database links
From: joel garry <joel-garry_at_home.com>
Date: Wed, 6 Jul 2011 14:37:49 -0700 (PDT)
Message-ID: <996b6715-820e-4dc2-8271-4825402cdb54_at_hd10g2000vbb.googlegroups.com>
On Jul 6, 1:01 pm, Krzysztof Cierpisz <ciape..._at_gmail.com> wrote:
> 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
Date: Wed, 6 Jul 2011 14:37:49 -0700 (PDT)
Message-ID: <996b6715-820e-4dc2-8271-4825402cdb54_at_hd10g2000vbb.googlegroups.com>
On Jul 6, 1:01 pm, Krzysztof Cierpisz <ciape..._at_gmail.com> wrote:
> 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
Not sure, I'd have to play with it, don't have time. But it should be. What versions did you say?
jg
-- _at_home.com is bogus. http://www.wired.com/dangerroom/2011/07/plenty-of-blame-to-go-around-for-disappearing-warship/Received on Wed Jul 06 2011 - 16:37:49 CDT