Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!postnews.google.com!g9g2000yqb.googlegroups.com!not-for-mail
From: Krzysztof Cierpisz <ciapecki@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: querying over multiple database links
Date: Thu, 7 Jul 2011 01:07:47 -0700 (PDT)
Organization: http://groups.google.com
Lines: 29
Message-ID: <48261bc4-83ff-4c5c-a66a-7e2cd04b1dad@g9g2000yqb.googlegroups.com>
References: 08ff6e30-35af-460f-ab73-723732360671@u30g2000vby.googlegroups.com
 <aa249436-2724-4d92-adee-297734e4579d@f39g2000prb.googlegroups.com>
 <d02abfed-a7e3-4dd8-99e7-aa3872d4fe63@t9g2000vbv.googlegroups.com> <996b6715-820e-4dc2-8271-4825402cdb54@hd10g2000vbb.googlegroups.com>
NNTP-Posting-Host: 193.9.13.138
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1310026068 12909 127.0.0.1 (7 Jul 2011 08:07:48 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 7 Jul 2011 08:07:48 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: g9g2000yqb.googlegroups.com; posting-host=193.9.13.138; posting-account=3B7smAoAAABmq17rxiCog3-OpP2Mfh_S
User-Agent: G2/1.0
X-Google-Web-Client: true
X-Google-Header-Order: ASELNKCHRU
X-HTTP-UserAgent: Mozilla/5.0 (X11; Linux i686) AppleWebKit/534.24 (KHTML,
 like Gecko) Chrome/11.0.696.68 Safari/534.24,gzip(gfe)
Xref:  news.cambrium.nl

On Jul 6, 11:37=A0pm, joel garry <joel-ga...@home.com> wrote:
> On Jul 6, 1:01=A0pm, Krzysztof Cierpisz <ciape...@gmail.com> wrote:
>
> > On Jul 6, 7:35=A0pm, joel garry <joel-ga...@home.com> wrote:
>
> > > It's been too long since I've done this, but I think what you want to
> > > do is desc <yourpublicsynonym>@<remove_database2> (or select * from
> > > user_db_links@<remote_database2>, then if you can see that, you have
> > > to make some bizarro usage with quotes and @ signs like desc
> > > 'table_name@<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. =A0But it should
> be. =A0What versions did you say?
>
> jg
> --
> @home.com is bogus.http://www.wired.com/dangerroom/2011/07/plenty-of-blam=
e-to-go-around-...

I am on 11g

--
chris